How do I switch Rows to Columns?

I have data in rows that I would rather have it viewed in the columns section:

example:

a b c
1 x y z
2 x y z
3 x y z

but i want it to be

a b c
1 x x x
2 y y y
3 z z z

thanks

Hi

Copy the data, go to either another sheet, or to a space on the current sheet, then go
edit, pastespecial, values, transpose.

You can then copy over the original data.


IF you want to keep the original data, but just display transposed, then have a look at the TRANSPOSE function.

HTH

rylo