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?
Copy the cells, select edit and "paste special" then selct "transpose" from the options dialog box that apeears. Voila!
wow its that simple?
great, thnx :)