After you import the data, put this in B1:
=INDEX(A:A,(ROW()*2-1))

Put this in C1:
=INDEX(A:A,(ROW())*2)

Select B1:C1 and drag down (about halfway)

Then select columns B:C and edit|copy, edit|paste special|values

And delete column A.

Jagiellon Wilson wrote:

I want to import a text files into Excel and have very other line in a
different column

Like this, the original plain text file (txt):
A
B
C
D

Excel:
A | B
C | D

Is this doable in Excel?

Thanks

--

Dave Peterson