Forum Discussion
pbrainard
Helper III
Helper IIIConcatenate three columns then split into rows
I need to concatenate these three columns, separated by delimiter. Sometimes there will only be one ID, sometimes two, and sometimes three. If there is no ID, it's a null value. Here is wh...
Hi pbrainard
The IDs are Number, not Text, try
= Table.AddColumn(#"Renamed Columns", "Text.Combine", each Text.Combine((List.Transform({[Employee ID],[Employee ID2],[Employee ID3]}, Text.From), "; "))
Hi pbrainard
The IDs are Number, not Text, try
= Table.AddColumn(#"Renamed Columns", "Text.Combine", each Text.Combine((List.Transform({[Employee ID],[Employee ID2],[Employee ID3]}, Text.From), "; "))