I have set up a COVID 19 last minute ordering site and the orders can be exported. The issue is the file comes in a very impractical format.
I need to be able to highlight for example 'beer' and then know how many there are on order in total. I have conditional formatted the word Beer to come up in Red, but is there a way of being able to get excel to then collate all the Beers and the cell next to it (with the amount) to one place so instead or trawling through every one, Excel can group them all together so I get a total. I am also having the same issue with the delivery dates. In summary, I want the spreadsheet to be able to spit out same delivery day orders together and also be able to do summary of total products ordered.