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...
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...