Expend Table column in one row

[pandeyamitk]

We have a table in power which contains list of data and table inside column. I need to expand all the column but duplicaiton row should not be created. However the table inside column (Project_Member) contains 3 or more rows. Whenever we try to expend column table with selected column it is multiplying with number of rows listed in column (Proejct_Member) table. I am looking to have one original row for each but table column values should be concatinated using separator ", ". 

Here is attached screenshot.

Expected Reslult -

We need result link this in columns

Thank you

Amit

[ChielFaber]

For both columns you could use the technique described in the following blogpost by GorillaBI:

https://gorilla.bi/power-query/group-by-to-concatenate-text/

It uses the group by function with the Text.Combine function in Powerquery. The output will be the result your looking for albeit that the example is just for one column. You could adjust the code to use it for two columns.