algarraala
New Member
- Joined
- Jul 14, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello everyone,
I am trying to write a macro to distribute elements into matrices of defined (by user) number of rows and columns. Consider a raw data like this:

And I want to distribute in Matrices of, for example, 12 rows x 8 columns but each Element group must start at the beginning of a column even if the previous one was not completely filled. I would like to get the results in a table like this:

This is a visual representation of what I tried to explain above, perhaps it helps to understand it better:

Would the code be very different if the data was taken from a source spreadsheet and written in a new one?
Thank you so much for your help!
I am trying to write a macro to distribute elements into matrices of defined (by user) number of rows and columns. Consider a raw data like this:

And I want to distribute in Matrices of, for example, 12 rows x 8 columns but each Element group must start at the beginning of a column even if the previous one was not completely filled. I would like to get the results in a table like this:

This is a visual representation of what I tried to explain above, perhaps it helps to understand it better:

Would the code be very different if the data was taken from a source spreadsheet and written in a new one?
Thank you so much for your help!