Forum Discussion
Expend Table column in one row
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_Membe...
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.