Power query - table aggregation in text format

Question

Hello,&nbsp;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 oneMore practically, I have achieved to aggregate the text by column, with a delimiter&nbsp;What i try to achieve is:11 My first req, 3 My third req21 My firs req, 2 My second req, ......&nbsp;&nbsp;so combining multiple column when aggregatin.&nbsp;Is there a formula to achieve that, or i need first to create another table with merged cell before merging both tables.&nbsp;kr

anonymous · Accepted Answer

Hi&nbsp;olivort&nbsp;&nbsp;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&nbsp;Text.Combine( List.Transform( List.Zip({Text.Split([Column2],","),Text.Split([Column3],",")}), each Text.Combine(_, " ")),", ")&nbsp;&nbsp;

Forum Discussion

Power query - table aggregation in text format

1 Reply

Related content

Power Automate format

Data Aggregation issue

Aggregate

Power Query - Aggregate multiple columns within group by

Power BI Embedded and PBIR Format Support

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