Use the INDIRECT() function:

Assuming your data starts in A1, in B1 thru E1 enter:

=INDIRECT("A" & ROW()*5-4)
=INDIRECT("A" & ROW()*5-3)
=INDIRECT("A" & ROW()*5-2)
=INDIRECT("A" & ROW()*5-1)

and then just copy down
--
Gary''s Student


"dthmtlgod" wrote:

I have a list of records in this format

Name 1
Address 1
City 1
State 1

Name 2
Address 2
City 2
State 2

Name 3
Address 3
City 3
State 3

I would like to put these on a row for each record, i.e.

Name 1 Address 1 City 1 State 1
Name 2 Address 2 City 2 State 2

Any help is much appreciated.