How to automate changing a table to a structured list and exclude blanks

My goal is to take a table with any # of rows but limited number of columns like this:

And have it convert to this format with power query: 

etc

it omits any value <1 and iterates over all instances of column1 that exist. 

I've done about 4 hours of my own research trying to find out but having a hard time. Hoping an expert here can enlighten me. Thank you for your time