How to pull the column name in a row and their respective values

[Anonymous]

Hi everyone, I have got one table that contains some values. I want to create another table with certain conditions from the first one. I have attached a picture with a question and an expected solution. Is there any way we can do this? Looking for help. thank you

[amitchandak]

@Anonymous , Unpivot the the table and they filter non zero values in in power query

https://radacad.com/pivot-and-unpivot-with-power-bi
https://www.youtube.com/watch?v=2HjkBtxSM0g

to remove

https://community.powerbi.com/t5/Desktop/M-Power-Query-Removing-entire-rows-based-on-condition/td-p/367563

[mahoneypat · Accepted solution]

In the query editor, highlight your ID colum, right click and choose unpivot other columns.

Regards,

Pat