I have a worksheet with data in the following format;

A Value1
A Value2
A Value3
B Value4
B Value5
B Value6
C Value7
C Value8
C Value9
D Value10

What I'd need is a VBA macro to sort the data into multiple columns with only one topic, with all the values below which were next to the same topic, in a format following;

A B C D
Value1 Value4 Value7 Value10
Value2 Value5 Value8
Value3 Value6 Value9

I am quite sure there is a macro already done for this purpose, but I couldn't find one for this need.

Attached example file.
example.xlsx