Concatenate Varying # Of Columns in Power Query

Question

Hey all,&nbsp;I have a need to take my table, and concatenate each value in the first row into one cell, removing all others.&nbsp;So if the table looks like this in PQ. I need to consolidate all cells into one, with a ", " in between each one. The problem I'm running into is that each time I refresh the report, the total number of columns can be different, either growing or shrinking in total number so I can't hard-code a set number of columns, it has to be variable. Any suggestions is appreciated!&nbsp;&nbsp;

wdx223_daniel · Answer

NewStep=Table.FromColumns({Table.ToList(PreviousStepName,each Text.Combine(List.Transform(_,Text.From),","))},{"NewMergedColumn"})

Forum Discussion

Concatenate Varying # Of Columns in Power Query

1 Reply

Related content

Concatenate 3 columns

create custom column concatenated

Power query - concatenate text columns

Product ids of varying length

Concatenate lists ;