Courses / Power Query (Get & Transform)
14. Split Column by Delimiter
Splitting a column into multiple columns based on a delimiter using the Split Column action.
Power Query M
Split Column by Delimiter
Break a text column into multiple columns by chopping on a character or string (like commas or pipes).
"I need each CSV field in its own column so I can filter and calculate without messy text formulas."
Split Column by Delimiter takes each text value in a column, finds a delimiter (e.g., comma, semicolon, pipe), and produces new columns for the pieces so you can work with each piece separately.
"I need each CSV field in its own column so I can filter and calculate without messy text formulas."
Split Column by Delimiter takes each text value in a column, finds a delimiter (e.g., comma, semicolon, pipe), and produces new columns for the pieces so you can work with each piece separately.