Move cell dependent on another column

Hello All,

I'm attempting to create a spreadsheet which sources data from multiple worksheets.
This is being completed using Power Query in the most part however with the layout of one report I am unable to display this information as I wish.

On the image below I have made a simplified example of the produced report (Left) I wish to have the information displayed as on the right of the image.

Forum pic.jpg

Any fix whatsoever would be greatly appreciated and allow some much need rest on my part!

Thank you for taking the time to read,

Dan