VBA coding for Vertical to Horizontal depending on criteria

[kitsa]

Hi All,
I'm trying to create a VBA for automation from Sheet1 to Sheet2, but it's vertical on Sheet1 and would like it to be horizontal in Sheet2 as per example image.
Would like to know how to loop and if adding extra data if it will create new info?

 

[alansidman]

Unpivot your data with Power Query. If you reload your data using XL2BB then I can provide you with M code. We cannot manipulate data in a picture.

 

[kitsa]

I just manually created it and screen shot it. I don't know how to use what you have asked. Can I upload the spreadsheet on here?

 

[alansidman]

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com