Forum Discussion
Power Query - separating a column into multiple columns
Hi, Currently I have multiple data points located within one row cell in one column (please refer to the 'Current data' part in the snippet). In the Power Query Editor I'd like to transform t...
One option, you could try splitting the column by #(lf) to rows instead of columns, then use split column by delimiter : to seperate the name of the datapoint before the colon from the datapoint. Then Pivot those two columns.
If you need to retain the datapoint name e.g. Docs: in the body of the datapoint then you'd need to use Add Columns > Extract > Before Delimiter instead of Split Column by Delimiter when performing the second delimit operation.
Afraid that did not work, perhaps because I have additional columns in the data set? after splitting the column by #(If) to rows instead of columns, no changes occurred