Import data row->column

[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

 

[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

 

[Pierluigi]

No data separator except "new line break"

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