Transpose data from rows to columns

[yxz152830]

Gurus,
I have a data set that looks like this:

A	1​
A	2​
A	3​
B	1​
B	2​
C	1​
C	2​
C	3​
C	4​

I'm hoping to convert the set to this:

A	1​	2​	3​
B	1​	2​
C	1​	2​	3​	4​

is there a way to do it without VBA?
Thanks in advance!

 

[yxz152830]

Another option with a formula

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	A	1		A	1	2	3
3	A	2		B	1	2
4	A	3		C	1	2	3	4
5	B	1
6	B	2
7	C	1
8	C	2
9	C	3
10	C	4
Sheet6

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(A2:A10)
E2:G2,E4:H4,E3:F3	E2	=TOROW(FILTER($B$2:$B$10,$A$2:$A$10=D2))
Dynamic array formulas.

Yes sorry it's working! thanks for the solution!

 

[Fluff]

You're welcome & thanks for the feedback.