Convert Rows To Columns

@LeoTaxi - helped me out a week or so ago with a similar issue. This time I need to create 1 row for each ID and copy over each item, quantity and add a blank column, then the next item, qty and blank column.

Attached is a sample workbook of the current format that shows what the data is in, and the desired format, that shows how I need the data formatted.

I appreciate any and all who assist

@fshbet -> this does not set-up the header information. Is there a way to also include the header info like I show in my sample workbook?