I have had a search of this and cannot seem to find exactly what I am
looking for, so apologies if this has already been asked!
I have been given a dataset with around 50 columns by product type (e.g.
Cornflakes, Bread, Milk etc) going across 1 sheet. Each column has over
2000 rows with the store type and revenue for each store. The number of
stores is different for each column (e.g. cornflakes sold in 100 stores,
bread sold in 200 stores etc).
What I would like to do is to sum the total revenue for each store e.g.
Store 1 makes £120 across all products etc.
Unfortunately, the stores are in different orders in the columns and not
all the columns have the same store. E.g. Cornflakes might have store 1,
3, 5 and 6, Bread might have store 2, 3, 4 and 5, Milk has 4, 2 and 1
I have tried to lay out what I am looking at below, but if I have not made
myself clear, I will try and send across the Excel.
Store No. Revenue (£) Store No. Revenue (£)
Store 1 100 Store 1 20
Store 2 78 Store 2 55
Store 3 49 Store 3 82