Copy address label from row to column

Hi David,

Are ALL of your addresses 3 rows? If so, and assuming your first address starts in cell A1, then in B1 put this formula:

Please Login or Register  to view this content.

Fill this formula into C1 and D1, then fill it down as many rows as you need.

If you had 10,000 rows of addresses, then you'd need to fill down about 3,334 rows. You could fill all the way down, but you'd get about 6,700 rows with zeros.