Single Column to Rows [closed]
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