I may have in some excel reports, into one single cell, multiple values and I want to extract them so I can have one row for each value. Since in Power BI, there is an option to do it, there is no need to do it in excel. I will explain the way to do it with 1 and multiple separators. Imagine I have this data (left picture) and I want to reach the final result (right picture):

To do it, I will have to go to the editor:

• Home -> transform data -> transform data

• Select the column I want to extract
• Home -> split column -> by delimiter

You will get this popup:

• In the field “select or enter delimiter”, I will select “space” because as you can see my data, values are separated by a space.
• Expand the “advanced options” and select “row”
• Click “OK” and it is done.

Imagine that I have different separators like that:

I can repeat the same steps as above for each separator but the best way is to use only 1 time so I will go back to the editor then on the “applied steps”, select “split column by delimiter”:

On the formula, change the “red” part:

By: SplitTextByAnyDelimiter({", ","-"," "},

NOTE: the order of the separators is important because it will start from left to right