ExcelBanter - How do I invert data so that the columns become rows??

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I invert data so that the columns become rows?? (https://www.excelbanter.com/excel-discussion-misc-queries/41079-how-do-i-invert-data-so-columns-become-rows.html)

jsloman

How do I invert data so that the columns become rows??

I have a block of data where I would like the columns to be rows and the rows
to be columns. Is there a simple way to flip the data?

Bernard Liengme

Use Copy followed by Edit|Paste Special-Transpose
Make a second copy of you file before doing this - just in case you mess up
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jsloman" wrote in message
...
I have a block of data where I would like the columns to be rows and the
rows
to be columns. Is there a simple way to flip the data?

All times are GMT +1. The time now is 08:28 PM.