Say you have a spreadsheet with data like this;
test test
test1 test1
test2 test2
test3 test3
test4 test4
test5 test5
test6 test6
and wanted to rotate it, so it was;
test test1 test2 test3 test4 test5 test6
test test1 test2 test3 test4 test5 test6
How would you do this? I have a spreadsheet with about 300 values and i need to rotate them like that to make a CSV file for a company I'm dealing with. So i don't want to do this programmatically if possible.
Thanks