We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

RebTech's profile - activity

2020-08-20 00:07:26 +0200 received badge  Famous Question (source)
2017-12-19 06:54:55 +0200 received badge  Taxonomist
2015-04-09 21:31:43 +0200 received badge  Notable Question (source)
2015-04-09 16:53:47 +0200 answered a question Single Column to Rows

Ended up manually using "Copy", then "Paste Special" with 'Transpose' selected.

Not an elegant solution, but quick enough.

2015-04-09 08:30:09 +0200 received badge  Popular Question (source)
2015-04-08 23:32:52 +0200 asked a question 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