CSV Order Summary Structuring

I’m providing a raw CSV file that lists every line of an apparel order. I need it reorganised into a single Microsoft Excel worksheet where the data is cleanly sorted into columns by product name, size category (clearly separating Adult and Youth), and colour. Every item must slot into its correct place so I can read totals at a glance and run simple pivot-table analysis later if I wish.

All information you need is already in the CSV; no data hunting or validation against external sources is required. Just transpose, sort, and present it neatly.

Deliverable: one .xlsx file containing that single, well-structured sheet—ready for immediate use in Excel.