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!