Transpose column data to rows

[banglong]

Hi,

Need your help to transpose 2 columns of my data from this:

COL. A COL.B
A 1
A 2
B 1
B 2
B 3
C 4
C 5
C 6
C 7

convert to this:

COL. A COL.B COL.C
A B C
1 1 4
2 2 5
3 6
7

Thanks in advance.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	A	1		A	B	C
2	A	2		1	1	4
3	B	1		2	2	5
4	B	2			3	6
5	B	3				7
6	C	4
7	C	5
8	C	6
9	C	7
Main

Cell Formulas
Range	Formula
D1:F1	D1	=TRANSPOSE(UNIQUE(FILTER(A1:A20, A1:A20<>"")))
D2:D3,F2:F5,E2:E4	D2	=FILTER($B$1:$B$20,$A$1:$A$20=D$1)
Dynamic array formulas.

 

[banglong]

EXAMPLE AS ATTACHMENT..THANKS

 

[Fluff]

Did you try my suggestion?

 

[banglong]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	A	1		A	B	C
2	A	2		1	1	4
3	B	1		2	2	5
4	B	2			3	6
5	B	3				7
6	C	4
7	C	5
8	C	6
9	C	7
Main

Cell Formulas
Range	Formula
D1:F1	D1	=TRANSPOSE(UNIQUE(FILTER(A1:A20, A1:A20<>"")))
D2:D3,F2:F5,E2:E4	D2	=FILTER($B$1:$B$20,$A$1:$A$20=D$1)
Dynamic array formulas.

very nice...thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.