Hi,
I have a list of addresses that need to be in a different format. The
addresses are currently in this format:
Atria Chandler Villas
101 S. Yucca Street
Chandler, Arizona 85244-8419
Chandler, Arizona 85244-8419
(blank cell)
Atria Bell Court Gardens
6653 E. Carondelet Drive
Tucson, Arizona 85710-2155
520.886.3600
(blank cell)
Atria Campana del Rio
1550 East River Road
Tucson, Arizona 85718-5800
520.299.1941

I need them in rows instead of columns, like this:
Atria Chandler Villas 101 S. Yucca Street Chandler, Arizona
85244-8419 Chandler, Arizona 85244-8419

The pattern is as follows for the names:
=B1
=B6
=B11
The names are by 5 but excel AutoFill does not recognize this pattern
to continue by adding 5 to the cell number.

Does anyone know a way to get around this? (fill series doesnt work
with a series of cell names)

Thanks.