transform excel table

Hi,   I have a excel tabel like below and i want to output as in the image. both of them are on the same image. I would like to know the PowerQuery transformation.   any help would be appriciate...