Copying 1 column into multiple columns

J

Jshendel

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!
 
P

PY & Associates

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
 
J

Jshendel

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