Well, that doesn't work for rows 3 on.

Kinda goofy, but it appears to work for all the rows:

=OFFSET($A$1,(ROW()-1)*8+COLUMN()+2*(ROW()-2),0)


"Duke Carey" wrote:

OK, assuming your data starts in A1, then use this in the first row in
B1:I1

=OFFSET($A$1,(ROW()-1)*8+COLUMN()-2,0)

and this for all subsequent rows

=OFFSET($A$1,(ROW()-1)*8+COLUMN(),0)


"Ed" wrote:

It did not work for me.
The file is set like this:

A + XXXXXX.
Clifford XXX
PO Box 7028
XXX, NC 28241-7028 US
Phone: (XXX) XXX-XXXX
Fax: (704) XXX-XXXX
Email:
Web: www.XXXXX.com

2 line row spacers
repeat again same 8 rows of new data

Hope you can figure this one out.
tks
"Ed" wrote:

I have a repetitive text file of contact information and want to place the
data in columns.
The file looks like this:
company
address
city
phone fax
email

company
address a nd etc...

I want the data go to respective colmns.
Help