Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Single Column to Rows

I have a text file with a single line of information which needs to be ultimately parsed into a DB.

File looks like this:

CustomerID1 CustomerName Street CityST

CustomerID2 CustomerName2 Street2 CityST2

and so on for 2000 lines.

I need to know if there is way to manipulate this in CALC to create:

CustomerID1 CustomerName1 Street1 CityST1 CustomerID2 CustomerName2 Street2 CityST2

with each former row being a separate cell.

Transpose swings the whole column into one row, I need one row per customerID. Thanks