Forum Discussion
Solved
row duplication when expanding a table column
In query when expanding a table column, rows duplicate like this: becomes I understand why this happens, but is there any way to instead of duplicating t...
Hi,
Try adding a column in Power Query before expanding the Column 2:
= Text.Combine(Table.Column([Column 2], "Fruit"), ", ")
where "Fruit" is the name of the column in the table that is concatenated and needs to be changed to match your data setup.
Hope this helps,
radpir
radpir
Resolver II
Resolver IIHi,
Try adding a column in Power Query before expanding the Column 2:
= Text.Combine(Table.Column([Column 2], "Fruit"), ", ")
where "Fruit" is the name of the column in the table that is concatenated and needs to be changed to match your data setup.
Hope this helps,
radpir
worked brilliantly.
thank you