I have a list of numbers in column A that i would like to be seperated into every other column in groups of X amount. Sometimes it can be 15 and sometimes it can be 18. I would like the user to be able to select the amount the groups, the amount of the columns and the amount of the rows the data will be broken out into.
The data needs to be pasted into a program that only accepts it in a particular way.
I want the data to go from this:
Column A
1
2
3
4
5
6
7
8
9
To this (if the user selects groups of 3, 3 columns, 3 rows.)
Column B Column C Column D
1 4 7
2 5 8
3 6 9
Any help would be appreciated.
Thanks
Bookmarks