Arrange values in columns

[wkhor]

I need some help to create a macro that will arrange multiple values in columns for all available rows such that they form a matrix.
I have attached an example of the before and after macro results.
The number of columns and rows may vary.

Any help would be much appreciated.

wk