What is TRANSPOSE called in Spanish?

In Spanish Excel it is TRANSPONER. The formula =TRANSPOSE(A1:B6) is written =TRANSPONER(A1:B6) (or with commas in Mexico).

Why does TRANSPOSE use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel TRANSPOSE function

Turns rows into columns and columns into rows, linked to the original data. In Spanish Excel it is called TRANSPONER.

Syntax

English Excel

=TRANSPOSE(array)

Spanish Excel (Mexico)

=TRANSPONER(matriz)

Spanish Excel (Spain, Latin America)

=TRANSPONER(matriz)

Argument	What it is
array	The range to turn.

Example

TRANSPOSE turns a range on its side: rows become columns. In Excel 365 the result spills by itself and stays linked to the original data, unlike Paste Special › Transpose.

=TRANSPOSE(A1:B6)

Common mistake

In Excel 365 it spills by itself. In older versions select the destination range and confirm with Ctrl+Shift+Enter.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice TRANSPOSE

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/218

My Excel is inExcel functions in English and Spanish

TRANSPOSE: rows into columns

TRANSPOSE turns a range on its side: rows become columns. In Excel 365 the result spills by itself and stays linked to the original data, unlike Paste Special › Transpose.

Example=TRANSPOSE(A1:B6)TRANSPONER = TRANSPOSE

In D1, show table A1:B6 horizontally, with the items in row 1 and the amounts in row 2.

	A	B
1	Item	Amount
2	Rent	8,500.00
3	Electricity	650.00
4	Internet	499.00
5	Groceries	4,200.00
6	Transport	1,100.00
7

Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.

Frequently asked questions

What is TRANSPOSE called in Spanish?: In Spanish Excel it is TRANSPONER. The formula =TRANSPOSE(A1:B6) is written =TRANSPONER(A1:B6) (or with commas in Mexico).
Why does TRANSPOSE use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common TRANSPOSE mistake?: In Excel 365 it spills by itself. In older versions select the destination range and confirm with Ctrl+Shift+Enter.