Ask Your Question
0

Single Column to Rows [closed]

asked 2015-04-08 23:32:52 +0100

RebTech gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-20 00:08:08.619830

3 Answers

Sort by » oldest newest most voted
0

answered 2015-04-09 16:53:47 +0100

RebTech gravatar image

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

Not an elegant solution, but quick enough.

edit flag offensive delete link more
0

answered 2015-04-09 00:52:31 +0100

m.a.riosv gravatar image

updated 2015-04-09 00:53:08 +0100

Menu/Data/Text to columns ?

edit flag offensive delete link more
0

answered 2015-04-09 08:47:08 +0100

pierre-yves samyn gravatar image

Hi

I'm not sure I understand. If your file is as you describe, and each line of the file must be placed in a single cell, there is nothing special to do. At the opening in Calc dialog opens:

screenshot

Simply validate with OK.

On the other hand you write:

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

CustomerID1 CustomerName1 Street1 CityST1 CustomerID2 CustomerName2 Street2 CityST2

I guess it's a layout error due to the syntax of the forum. If you really wanted all records on a single line that would not be possible because there are only 1024 columns.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2015-04-08 23:32:52 +0100

Seen: 108 times

Last updated: Apr 09 '15