Reformat table

[ssuresh98]

Hello All,
I have an Excel table problem. It seems easy to solve but I cannot find a solution.


SOURCE TABLE:

A Rose
A Pen
A Pencil
B Apple
C Cake
C Orange
C Mango
C Lime

REQUIRED FORMAT:

A Rose Pen Pencil
B Apple
C Cake Orange Mango Lime

GURUS please help.

Thanks

 

[Belleke]

Does this what you want?
See attached.

 

[ssuresh98]

Does this what you want?
See attached.

Amazing. Thank you so much. This works perfectly.

 

[Belleke]

Thanks for the feedback.

 

[bosco_yip]

Here is a formula solution.



1] D2, copied down :

=IFERROR(INDEX(A$2:A$9,MATCH(0,INDEX(COUNTIF(D$1:D1,A$2:A$9),0),0)),"")

2] E2, copied across right until blank and all copied down :

=IF($D2="","",IFERROR(INDEX($B$1:$B$9,AGGREGATE(15,6,ROW($A$1:$B$9)/($A$1:$A$9=$D2),COLUMNS($A:A))),""))

Regards
Bosco