Vlookup multiple Values then Concatenate all values in One cell

[Neyme]

Hi,

Can one of the Excel gurus please help me with two formulas for one data set. The data is attached in the spreadsheet: "Product IDs". The data is a set of Master Product IDs (parent) and the Linked to them Products (children). I need to create a relationship between unique parents (Master Product IDs) and their children (Linked Products)

I need to create two formulas:

1. From the Data Set table, need to vlookup the unique value in column A (Master Product ID) and return comma delimited (concatenated) corresponding values from column B (Linked Products). So, the result will be as shown in Table 2.

2. From the Data Set table, need to vlookup the unique (de-duplicated) parent/children relationship in column A (Master Product ID) and return comma delimited (concatenated) corresponding values from column B (Linked Products). There are total 3 parent/children relationships in Table 1. So, the result will be as shown in Table 3.

I would really appreciate your help. Thank you in advance!

[oeldere]

This is a duplicated post

[Neyme]

Hi oeldere,

Sorry, I accidentally clicked twice on "Post" button. Will you be able to help me with the formula? The other post was replied to but the solution provided didn't solve the problem.

Thank you!!!!

[Neyme]

Hi oeldere,

Sorry, I accidentally clicked twice on "Post" button. Will you be able to help me with the formula? The other post was replied to but the solution provided didn't solve the problem.

Thank you!!!!

[Fotis1991]

Thread closed as duplicated.