I need an excel expert..

Job ID: 33764156

Budget: £250 – £750 GBP

Please see attached. Basically the export payment file we get from Sage (top section), lists every invoice being paid. We want excel to automatically group the amount payable per supplier (bottom section), with out having to reply on manual intervention.