Excel colums and rows

W

Walter Seaton

I have a large amount of data on an Excel sheet. It has five rows, with
columns running through to column BP.

I would like to change this layout by rotating the display so that I have 5
columns and 150 (or whatever the correct number is) of rows.

How can I do that?

Many thnaks.
 
G

Gordon

Walter Seaton said:
I have a large amount of data on an Excel sheet. It has five rows, with
columns running through to column BP.

I would like to change this layout by rotating the display so that I have
5
columns and 150 (or whatever the correct number is) of rows.

How can I do that?

Many thnaks.
Click to expand...

Select all the data, copy, paste special-transpose.
 
Top