0

Single Column to Rows [closed]

calc
parse

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

RebTech
16 ●1 ●2 ●1

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
16 ●1 ●2 ●1

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

Not an elegant solution, but quick enough.

edit flag offensive delete link

0

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

pierre-yves samyn
13011 ●2 ●18 ●67

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

0

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

25744 ●7 ●53 ●139

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

Menu/Data/Text to columns ?

edit flag offensive delete link

Question Tools

1 follower

Stats

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

Seen: 124 times

Last updated: Apr 09 '15

Related questions

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.9.3