Share via

Sort 1 column into multiple columns

Anonymous
2023-12-18T13:41:57+00:00

Hello everyone,

I have 1 column of data in excel, its 1000 rows long, but I am doing a data merge onto an imposition so need 10 columns instead.

So column one would have codes 1-100, column 2 would have 101-200 etc etc ending in column 10 having codes 901-1000

Can anyone help.

Microsoft 365 and Office | Excel | Other | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Rory Archibald 18,965 Reputation points Volunteer Moderator
2023-12-18T14:48:51+00:00

Or:

=WRAPCOLS(A1:A1000,100)

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2023-12-18T14:14:33+00:00

If you have Microsoft 365:

=MAKEARRAY(100, 10, LAMBDA(r, c, INDEX(A1:A1000, 100*(c-1)+r)))

where A1:A1000 is the column.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-18T16:55:53+00:00

    Thank you both this was perfect!

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2023-12-18T15:08:08+00:00

    That's a lot shorter!

    Was this answer helpful?

    0 comments