Hi,
I essentially have a table of thousands of rows of data. I need to count several columns that will contain the same text, for example
apples oranges strawberries rotten juicing fresh rotten juicing, fresh fresh
etc.
I wish to count, for each type of fruit, the number of entries that are each of the combinations: rotten, juicing, fresh. (I want all combinations, so any like "juicing, fresh" should be included in the pivot table as well, something like this:
apples oranges strawberries Total rotten 1 1 2 juicing 1 1 fresh 2 2 juicing, fresh 1 1 Total 2 2 2 6
Given ultimately there are about 40 columns that I will eventually need to count, I don't want to create a pivot table for each column (which is the only solution I can come up with at the moment)
So is it possible to create the above (single) pivot table???
Thanks
Bookmarks