Forum Discussion
Solved
Power query - table aggregation in text format
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 aggrega...
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(_, " ")),", ")
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(_, " ")),", ")