I don't under stand the last part when you say
"Keep the highlight on, replace "a" with "=a"" Can you explain?


Done

"PY & Associates" wrote:

If your data is in column A, you can only have 255 x 8 = 2,040 entries

Enter a1 in B1, pull down to fill to a8;
Enter a9 in C1, pull down to fill to a16;
Now highlight B1 to C8, pull across to fill as desired;
Keep the highlight on, replace "a" with "=a"
Done

"Jshendel" wrote in message
...
I have a large list of a few thousand rows. Is there a way to break up
this
list into multiple columns?

I want to have 8 entries into a column, then move to the next column and
add
the next 8 entries.
Thanks for your help!