AutoFill pattern based on cell locations

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofill cell references with a pattern of every 110 rows	Light	Microsoft Excel Worksheet Functions	3	13th Oct 2008 10:00 PM
AutoFill pattern based on cell locations	valoo	Microsoft Excel Misc	4	28th Jul 2006 09:39 PM
AutoFill pattern based on cell locations	alexvaloo@gmail.com	Microsoft Excel Discussion	0	28th Jul 2006 03:57 PM
How to detect all files with pattern dat which do not have path pattern log ?	Martin Caldwell	Windows XP Help	8	5th Dec 2005 10:02 PM
How to detect all files with pattern dat which do not have path pattern log ?	Martin Caldwell	Windows XP General	0	4th Dec 2005 05:17 PM