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!
Super Userngboss707 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!