Excell help needed

[Luminance]

Hey guys,

A friend of mine was busy in excell today, and wanted to swap a series of columns and rows with eachother and asked me, but i couldn't help him, maybe you can?

lets say something like this:

  1 1 1 1 1  
2 x b b b b
2 e x b b b
2 e e x b b
2 e e e x b
2 e e e e x

to something like this

   2 2 2 2 2
1 x e e e e
1 b x e e e
1 b b x e e
1 b b b x e
1 b b b b x

Is this:
1, posible?
2, how?

I've never done it with excell before, but it looks possible enough

anyone?

[Anonymous]

Copy the cells, select edit and "paste special" then selct "transpose" from the options dialog box that apeears. Voila!

[Luminance]

wow its that simple?

great, thnx