Forum Discussion
Split Columns into rows by column values.
Hi,
I've below table I want to split into country wise rows. How to achieve?
| Region | Country | Incident |
| EMEA | Ger; FR;IT;GR | 5 |
| AM | US;CA;MX | 1 |
| Expectation | ||
| Region | Country | Incident |
| EMEA | Ger | 5 |
| EMEA | FR | 5 |
| EMEA | IT | 5 |
| EMEA | GR | 5 |
| AM | US | 1 |
| AM | CA | 1 |
| AM | MX | 1 |
Anonymous , In power Query you have option Split by Delimiter(row), Use that -https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
2 Replies
Anonymous , In power Query you have option Split by Delimiter(row), Use that -https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/