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
CSV: Change rows into columns with OpenOffice or Excel
Forum rules
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
CSV: Change rows into columns with OpenOffice or Excel
Last edited by Hannes, Tech Support on Tue Oct 21, 2008 10:07 am, edited 1 time in total.
Reason: underlined link to Excel tutorial
Reason: underlined link to Excel tutorial
Re: CSV: Change rows into columns with OpenOffice or Excel
In the English version, it is 'Edit -> Paste Special..." rather than "Insert Content..."