Power query - table aggregation in text format

[olivort]

Hello,

I have merged two query and try to expand the table by agregating text. The table to expand has several columns that i want to expand into one

More practically, I have achieved to aggregate the text by column, with a delimiter

What i try to achieve is:

1	1 My first req, 3 My third req
2	1 My firs req, 2 My second req, ...
...

so combining multiple column when aggregatin.

Is there a formula to achieve that, or i need first to create another table with merged cell before merging both tables.

kr

[Anonymous · Accepted solution]

Hi @olivort 

I am not sure how you get here, so maybe you can do it before it comes to these 2 columns. From what you have now, here is one way

Text.Combine( List.Transform( List.Zip({Text.Split([Column2],","),Text.Split([Column3],",")}), each Text.Combine(_, " ")),", ")