Pivoting data into one line from a long list of data. Help!

I'm hoping one of you guys could help me with this.

Attached is some sample data I need transforming. When the file is opened our supplier provides the data in the format at the bottom of the sheet and the data needs to look like the top part to be able to get the data into our system.

Could the data be changed in the Power Query Editor?

I know there isn't much details here as this is hard one to explain but easy to see in the data provided.

Thank you in advance for your help.
Luke