Import Text Data not in columns

[Pinkiredd]

I'm trying to import a text file, however the results are showing up in one
row instead of columns:

Original Sources layout:

A B C D
A B C D

When I use the import data wizard, the outcome is:

A B C D A B C D A B C D.

How do I get my information to reflect original formtat in columns?

 

[ShaneDevenshire]

Hi,

You can use a formula like this:
=OFFSET($A$1,0,COLUMN(A1)-1+4*(ROW(A1)-1))

Assume your data starts in A1 and extends to the right .
Copy the formula across 4 columns and down as many rows as necessary.