Converting 'vertical' address list to 'horizontal'

[kgarry1]

I have a sheet full of addresses formatted vertically:

A1: Company1 Name
A2: Company1 Address
A3: Company1 City, Zip

A6: Company2 Name
A7: Company2 Address
A8: Company2 City, Zip

I want to show this data horizontally:
A1: Company1 Name
B1: Company1 Address
C1: Company1 City, Zip

A2: Company2 Name
B2: Company2 Address
C2: Company2 City, Zip

I can do this easily for 1 address, but my data source includes over 1000 addresses. I'm unable to get the cell references to offset beyond the 1st record.

Any ideas?
Thanks in advance...

 

[Guest]

If your data is uniform (each company consisting of 5 lines) then your can put these formulas in adjacent columns, starting at row 1:

=OFFSET($A$1,5*ROW()-5,0)
=OFFSET($A$1,5*ROW()-4,0)
=OFFSET($A$1,5*ROW()-3,0)

and copy down.

 

[Ian Mac]

A few people help me out with a similar problem, try this link

http://www.mrexcel.com/board/viewtopic.php?topic=369&forum=2