Forum Discussion
MartynasBI
3 years agoFrequent Visitor
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...
halfglassdarkly
3 years agoResponsive Resident
Hi, if your data points always appear in the same order then you should be able to use Split Column by Delimiter with #(lf) as a custom delimiter. That will split your column value using the line feed as the delimiter.