Forum Discussion
Join colums to create a separated table?
Hello,
I am having trouble with this table:
Each line is a person identified by the ID column, and on the columns Cliente 1, Cliente 2, Cliente 3... are the clients wich each person is associated. I need to create a visual something like a table that shows how many people i have allocated with each Client, and list these people. I thought of creating a dimension table with 2 columns: ID column; and a result of joining the Cliente columns and if the person has more than 1 client, repeat the id and a new row for the client. Something like this
I dont know if it is possible to do this on power query so if guys have an alternative solution im all ears.
Thanks for the attention.
If you select first 3 columns in Power Query, then Unpivot Other Columns, that will give you a good base table to create the visual required
1 Reply
- HotChilli
Community Champion
If you select first 3 columns in Power Query, then Unpivot Other Columns, that will give you a good base table to create the visual required