Assume your source names running in A1 down
In say, B1: =OFFSET($A$1,ROWS($1:1)*10-10+COLUMNS($A:A)-1,)
Copy B1 across by 10 cols to K1, fill down as far as required to exhaust the
source data (until zeros appear).

Adapt the expression easily to suit:
a. $A$1 is the anchor cell = the top cell in the source range
b. The "10" is the number of cols that you want to fill across
(The above expression is left intentionally unsimplified to show the pattern)

Success? Celebrate it, hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"jerminski73" wrote:
I have a customer list of over 300 names that I want to autofill from a
selected data entry range. I would prefer to go 30 rows by 10 columns if
possible but will take whatever I can get. Thanks in advance!