Excel Macro requirement

I need an excel macro developed to automate some changes I regularly make to an excel document.

The original report is downloaded in excel and consists of 32 columns. The macro will reduce this to 14 columns and will also need to group and sum some of the columns as well.

The report consists of payments received from our customers and each customer payments will need to be grouped together so we can see the totals for each customer.

We do have example excel files of the before and after requirement so I can share these on request.