software

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!

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 quot;aquot; with quot;=aquot;
Done

quot;Jshendelquot; gt; wrote in message
...
gt; I have a large list of a few thousand rows. Is there a way to break up
this
gt; list into multiple columns?
gt;
gt; I want to have 8 entries into a column, then move to the next column and
add
gt; the next 8 entries.
gt; Thanks for your help!
I don't under stand the last part when you say
quot;Keep the highlight on, replace quot;aquot; with quot;=aquot;quot; Can you explain?gt; Done

quot;PY amp; Associatesquot; wrote:

gt; If your data is in column A, you can only have 255 x 8 = 2,040 entries
gt;
gt; Enter a1 in B1, pull down to fill to a8;
gt; Enter a9 in C1, pull down to fill to a16;
gt; Now highlight B1 to C8, pull across to fill as desired;
gt; Keep the highlight on, replace quot;aquot; with quot;=aquot;
gt; Done
gt;
gt; quot;Jshendelquot; gt; wrote in message
gt; ...
gt; gt; I have a large list of a few thousand rows. Is there a way to break up
gt; this
gt; gt; list into multiple columns?
gt; gt;
gt; gt; I want to have 8 entries into a column, then move to the next column and
gt; add
gt; gt; the next 8 entries.
gt; gt; Thanks for your help!
gt;
gt;
gt;