Forum Discussion
dgdgdg122db
6 years agoHelper II
Add rows based on columns
Hi,
I have a table looks like this:
There are 6 extra columns indicating different customer IDs and locations under the same user.
What I would like to achieve is to spit these 6 columns in to three rows, like this:
Please help
- Not sure because you refer to 3 but also to 6 but unpivot your last 3 columns.
2 Replies
- Greg_DecklerCommunity ChampionNot sure because you refer to 3 but also to 6 but unpivot your last 3 columns.
- camargos88Community Champion
Hi dgdgdg122db ,
Check this file: Download PBIX
I assumed the column "customer_ids/22" is like "customer_ids/22/region" like the others.
If no, let me know.