In different data i have the same problem as this:
(example is from 11 years ago, hoping to find an answer..)
I have a column of category and in it contains various types repeated throughout my sheet.. I need to graph based on that column but i receive multiple outputs of the same category..
Column A --- Column B
In the above example i want 3 categories in the chart showing percentages of the whole to be "Cat 10%", "Dog 60%", and "Horse 30%".
Instead what happens is i get 4 categories and Dog is repeated twice with percentages 20 and 40. How can i combine categories from column A that are the same value for my chart?
I've included the attachment of my sheet for reference ** My data for category is Hunting/Fishing, Garden, Electronic, Gun, etc***