- Apr 28, 2004
- Office Version
Here's the M code for adding the new column.
You could try incorporating that into the M code for the query that's pulling in the data.
Table.AddColumn(#"Changed Type", "ReplaceMultipleDelimiters", each ReplaceMultipleDelimiters([Column1], ","))