Change data to appear in rows instead of columns (reverse a table.

  • Thread starter Motheroftwoboys
  • Start date
M

Motheroftwoboys

I have a fairly large table in which I need to switch the columns to the
rows. Is this possible to do?
 
P

Peo Sjoblom

I would use a help sheet, select the table, copy it, select the first cell
where you want it on the help sheet,
do edit>paste special and select transpose. Obvisouly if you do it the other
way you have to
bear in mind that you can only transpose 256 rows due to the max number of
columns
 
G

Guest

hi,
excel will pastespecial>transpose a single column but i am
not aware of an easy way to do a whole table.
you said large table. if you are transposing columns to
rows then you are also tranposing rows to columns and if
you have more that 256 rows to transpose, then you wont be
able to do this because that is all the columns that excel
has.
 
Top