Excel Whizz Required: I need a line order report reformatted for AWeber CSV import

General information for the business: Mens Hair Products
Description of excel work: I have a line report in Excel (From Woocommerce) with 7340 orders with date of order, first name, surname, country, item purchased, total value of order. The report contains orders from customers that have ordered multiple times and sometimes with 1 or more items in the order.

I want to import this into AWeber email platform so I can target by date of order (for lapsed customers), items purchased (to market other products in the range) and order value (i.e high spenders).

- I need help combining all products ordered and spend data into one row.
- I would like the total spend for that customer to appear in the total spend column
- I would like all items purchased to appear in one cell separated by a comma (These would act as tags in AWeber.

For example:

M Smith m.smith@gmail.com product 1, product 2, product 3 £150.50

I hope this makes sense. This should be a quick and easy job for an Excel whizz.

I look forward to your quotes.

Please let me know if you have any questions.

Many thanks

Matt
Extra notes: