Good day everyone!

I have a problem and i cant solve it myself, trying my luck here if anybody had ever encountered this. I have a picture attached here and i want to convert table 1 to table 2. Is there anything in excel that can do this automatically since i have a total of 1206 different type of "table 1" and doing it manually will take me a whole lot of time.

Hope somebody find time to answer this. Thank you!

Table.jpg