Forum Discussion
Pivot with multiple values scatered thorugh rows + nulls (Powerquery)
ngboss707 it will be easier if you unpivot this:
Transform data -> select IP -> right click -> Unpivot other columns
it will create two column, attribute and value, rename as you see fit, close and apply
Use matrix visual, put IP on rows, attribute on column and value on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
ngboss707 it will be easier if you unpivot this:
Transform data -> select IP -> right click -> Unpivot other columns
it will create two column, attribute and value, rename as you see fit, close and apply
Use matrix visual, put IP on rows, attribute on column and value on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Hi parry2k, thanks for the help! This formatted the table correctly, although all lines are appearing blank for me.
I changed some settings in the values field, but I can't find how to display the 'values' text instead of totals or counts. I chose to create a quick text measure to concat the fields but the result still is the same. When expanding the value cells I can see that it's also counting the blanks and dupes.