Forum Discussion
Solved
Split Columns
I need to split a column with a delimiter of "-". However, this column does not always have an equal amount of, what I will call, splits. Plus, I have a Project Name that sometimes has the delimite...
hi DPCCGF ,
try to split the column by each occurence of delimiter into rows.
check more here:
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
This worked but I now have project ids (which is the key) with 5 rows, 6 rows or 7 rows. This is because the split column does not always have the same number of splits. Hope I am making sense. I actually did a count of rows on the project Id and it ranges from 6-10
