invert Lines and column on Excel

[Guest]

How i can invert Lines / column in Excel
There is way ?
Tks

 

[SteveW]

Do you mean invert or transpose ?

Steve

 

[Guest]

Probably transpose, as transposition is a kind of inversion.

Anyway, to transpose either:

1) Select the row in question. Copy it, select the top of the column to
which you want to transpose the row, paste special, transpose.

2) Use the TRANSPOSE function (which requires an array formula). Here, you
select an amount of cells equal to the number of cells you want to transpose,
then enter =TRANSPOSE([range to be transposed]) and commit the formula with
CTRL + SHIFT + ENTER.

Dave

 

[Gord Dibben]

Invert or Transpose?

To transpose, select and copy then paste special>transpose.

To invert you would need a helper row or column and formulas.


Gord Dibben MS Excel MVP