Tough one (atleast for me). I am trying to group similar data in Excel. Below is a picture of what I am looking at and an explanation of what I am trying to do:
The Value's across the top are the values for each zone.
The letters down the left side are different variables for each zone.
Some variables go that specific zone and some do not.
For instance "A" goes to All of the zones as does "C". "B" however only goes to zones 1, 1A, and 2.
I am needing for Excel to split these and list which "variables" (Column A) and final value totals for each different group of variables.
So "A and B" would be a total of 29,483 as they go into all of the zones, and then it would also list "A,B,C" and a total of 25,651 since that only goes into Zone 1, 1A, and 2.
I am needing those listed together in a easy to view table.
Solved by F. F. in 19 mins