Power Query - Present Data from Colom to Row

Hi,
I am trying to learn how to user Power Query.

What function do we use to convert some of the information from Column to Row and then combining them into one list. I have attach a sample file as the original file is very very big. Thanks Expert.

I have update the table with correct out put arrangement and PowerPoint image on the concept on how the current data is replicated manually. Hope expert can help. Thanks