My feed
Premium

Please
or
to access all these features

Geeky stuff

Is there an easy way to flip/transpose an Excel spreadsheet...?

2 replies

WilfSell · 03/09/2008 13:45

...so that the rows become the columns and the columns become the rows?

Thanks!

OP posts:
Report
n5rje · 03/09/2008 14:36

Have you tried this ?

Transpose rows to columns or columns to rows

Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.

Select the cells that you want to switch.
Click Copy .
Select the upper-left cell of the paste area. The paste area must be outside the copy area.
Click the arrow to the right of Paste and then click Transpose.

Report
WilfSell · 04/09/2008 11:39

A ha! thank you very much - that worked!

OP posts:
Report
Please create an account

To comment on this thread you need to create a Mumsnet account.