CSV: Change rows into columns with OpenOffice or Excel
Posted: Wed May 09, 2007 7:20 am
OpenOffice Calc and MS Excel both provide means to reverse/invert a CSV
Name1, Address1, URL1
Name2, Address2, URL2
Name3, Address3, URL3
into this format:
Name1, Name2, Name3
Address1, Address2, Address3
URL1, URL2, URL3
Using OpenOffice Calc
a) Mark lines to be reversed
b) Cut data
c) Use "Insert Content...", with "Transpose" being checked. (Frankly, the keywords may be slightly different, as I tested this on a German version)
MS Excel
Follow this tutorial
Name1, Address1, URL1
Name2, Address2, URL2
Name3, Address3, URL3
into this format:
Name1, Name2, Name3
Address1, Address2, Address3
URL1, URL2, URL3
Using OpenOffice Calc
a) Mark lines to be reversed
b) Cut data
c) Use "Insert Content...", with "Transpose" being checked. (Frankly, the keywords may be slightly different, as I tested this on a German version)
MS Excel
Follow this tutorial