How to group information from a table

Hello,

I have a table with the following information:

A 1
B 2
C 3
A 4
B 5
C 6
A 7
B 8
C 9

And i would like to group by the first column so it would appear like this:
A B C
1 2 3
4 5 6
7 8 9

Can you please help me?

Thank you in advance.

Attachment shows one way using 3 helper columns and another way using an array formula.
Array formula must be entered using Ctrl+Shift+Enter PC key combination.

Beau Nydal