CSV: Change rows into columns with OpenOffice or Excel

Share your tips, tricks and favorite iMacros macros, scripts and applications for web automation in general here.

Moderator: iMacros Moderators

CSV: Change rows into columns with OpenOffice or Excel

by Hannes, Tech Support on Wed May 09, 2007 12: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
Last edited by Hannes, Tech Support on Tue Oct 21, 2008 3:07 am, edited 1 time in total.
Reason: underlined link to Excel tutorial
Hannes, iOpus Support
Hannes, Tech Support
 
Posts: 2120
Joined: Thu Sep 21, 2006 6:27 am

Re: CSV: Change rows into columns with OpenOffice or Excel

by steogede on Wed May 27, 2009 2:34 am

In the English version, it is 'Edit -> Paste Special..." rather than "Insert Content..."
steogede
 
Posts: 0
Joined: Wed May 27, 2009 2:28 am


Return to How-To's and useful iMacros: All other topics

Who is online

Users browsing this forum: No registered users and 1 guest

-->