I need to divide one column data into10-15 multiple columns evenly

Hi,

this is my first post. i need help in finding the way to separate the data from one column into multiple column. For example, let say column A has 1000 rows and i need to divide them between Column A to column J with 10 rows each.

in actual shee there are thousands of lines in one column and i need to distribute in multiple columns so i can finish my reseach easily.

Please help.

(a) If thousands of rows, do you want then divided from columns A to J with however many rows in each column, or do you want them distributed to however many columns with 10 rows in each?
(b) Does your "data" include formats or do you want only values copied? (Values only is faster)

For 10 rows in each column and copy formats as well as values, try

Please Login or Register  to view this content.

Or if you want a choice of rows.

Please Login or Register  to view this content.

FWIW:

Please Login or Register  to view this content.