Forum Discussion
Concatenate Varying # Of Columns in Power Query
Hey all, I have a need to take my table, and concatenate each value in the first row into one cell, removing all others. So if the table looks like this in PQ. I need to consolidate all cells...
NewStep=Table.FromColumns({Table.ToList(PreviousStepName,each Text.Combine(List.Transform(_,Text.From),","))},{"NewMergedColumn"})