Tue 5 May 2009
Transpose Open Office Calc data from rows to columns, or vice versa
Posted by Pablo Endres under HowTo, Technology
[6] Comments
I had to shift through a ton a data today and after I was have way through I realized that I would be easier to express and analyze the data if it was transposed o just filled in the other way around (rows and columns). On any other day or a different stage of the work I would have retyped it, but I got lazy and found this link and all you have to do is a special paste and check the transpose box.
Incredible!
The best thing is that it works both in M$ Office and Open Office.
Awesome, just what I needed
Thanks for posting this, I was about to open another beer and consider doing it manually! :p
This was a great help thanks!
Thank you, amazing! and nice plug about openoffice.org
And how does this work with Open Office, because I don’t see a transpose option in Special Paste?
Excellent! Just what I was looking for. Thanks for posting.