Different Fruit allocated numbers, group the orders

[slxia1]

If I am ordering 1 of A, 2 of B, 2 of C.

How can I get B,C to display next to 2?

[azumi]

Perhaps somethis like this?

[karedog]

Hi,

Need a helper column (column D) to do this. The formula at cell D2 :

Please Login or Register  to view this content.

copy down until D8

The formula at cell E2 :

Please Login or Register  to view this content.

copy down until E8

Regards

[slxia1]

thanks to the both of you! more solutions the merrier. Just to provide some additional info for others looking to solve this same issue..

The lookup method will only work after sorting.