help to solve problem

[Davidk]

I need to order data please help.


in column "A" i have user id. in column "B" i have several products which have this "id"

i need to have one "ID" in colimn "A" and all the product in one cell in column "B"


see attached file

 

[Hui]

Do a search for Concatif on the main Chandon.org page
Then read comments

 

[bosco_yip]

Or try this formula way with helper,

1] In "Helper" C2, formula copied down :

=IF(A2=A3,B2&","&C3,B2)

p.s. You can hide Col C as per your need.

2] In "ID" E2, formula copied down :

=IFERROR(AGGREGATE(15,6,A$2:A$12/(A$2:A$12>E1),1),"")

3] In "Product" F2, formula copied down :

=IF(E2="","",VLOOKUP(E2,A$2:C$12,3,0))

Regards
Bosco