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...
Hi halfglassdarkly ,
I've tried it, but since currently some rows have 3 distinct points (Status, CID and Period as per snippet above) while others have 5 (Status, CID, Period, Docs, Time taken), after the split using custom delimiter, the columns become inconsistent.
Please refer to the below of what I am referring to