Forum Discussion
How to split a column and sort outcome by column?
Hello - I understand the question is vague but I'm not entirely sure how to ask it in detail. Thank you in advance for any assistance. I am trying to split a column that lists regions, separated by a semicolon. My list looks something like:
| Person 1 | United States of America; Asia; EMEA; Canada |
| Person 2 | Asia; Canada |
| Person 3 | Europe |
| Person 4 | United States of America; Europe; Asia |
| Person 5 | Europe; Canada |
| Person 6 | Europe; APAC |
And the desired outcome would be as such (bold for column headers) - an alternate would be for the data to say "true" for each relevant column:
| United States of America | Asia | Europe | EMEA | Canada | APAC | |
| Person 1 | United States of America | Asia | EMEA | Canada | ||
| Person 2 | Asia | Canada | ||||
| Person 3 | Europe | |||||
| Person 4 | United States of America | Asia | Europe | |||
| Person 5 | Europe | Canada | ||||
| Person 6 | Europe | APAC |
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh1Vt8uY9RlqN7o9N?e=48zutjIf this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
1 Reply
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh1Vt8uY9RlqN7o9N?e=48zutjIf this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.