Display data horizontally

[cultgag]

Here is what I need, I saw something similar to this before but I can't find it now.

A 1
A 2
A 3
A 4

B 1
B 2

C 3
C 5

D 2
D 5
D 9

Instead of data growing vertically I need

A 1 2 3 4
B 1 2
C 3 5
D 2 5 9


All data in A will be in one row, B in one row etc..

(A, B are just generic names I came up with

i.e : I want to group all rows with name A(inspect A) to have just 1 row
instead of having one row for each data)

Any help will be greatly appreciated.

Thanks