Import data row->column

P

Pierluigi

Hi NG,

I didn't find the answer on line so here I am.



I need to import a file like:



A

B

C

D

A

B

C

D

A

B

C

D

....

and have it in excel like



A|B|C|D

A|B|C|D

A|B|C|D

...



Is it possible?

And if YES, how should I do it?

Excel 2003

File to be imported .txt (in the rows there is text, numbers and spaces)



Please let me know.

All the reply will be greatly appreciated.



Thank you for the help



Pierluigi
 
P

papou

Hi Pierluigi
What is the common data separator if any?
See settings with the text import Wizard or the Data, Convert option in
Excel to achieve what you want.

HTH
Cordially
Pascal
 
P

Pierluigi

No data separator except "new line break"


papou said:
Hi Pierluigi
What is the common data separator if any?
See settings with the text import Wizard or the Data, Convert option in
Excel to achieve what you want.

HTH
Cordially
Pascal
Click to expand...
 
Top