So I have the following raw data:
Pic 1.png
Is there a way of getting excel to make the sheet look like this so that multiple company entries are shown as a number count and also get excel to sum the amount in the spend column.
Pic 2.png
The excel doc is attached now (sorry about that!)
Many thanks in advance
Bookmarks