Apologies if this is covered somewhere in the forum but I just spent a good chunk of time looking for a solution here and on the interwebz and I couldn't find what I was looking for.
Basically I want to turn a data entry table into a frequency table with multiple columns. IE
the original data table looks like this
Person1 Person2 Person 3
A B A
A B A
A B A
A B A
A B A
A B B
A B B
A B B
A B B
A B B
and i want this output
Person1 Person2 Person3
A 10 0 5
B 0 10 5
before the last hour of searching for solutions or answers, i spent an hour jiggering with pivot tables without any success. I also tried using the histogram function in the data add-in pack but that seems to only want numeric data. Lastly, I looked though a ton of pivot table tutorials and none of them seem to be able to tell me how to do this.
is this something that can be done with pivot tables and i'm just not doing the right things with the fields? The best I've been able to come up with is 3 separate pivot tables that provide a frequency table for each person. There's got to be a way to do this in one step right? The actual data I'm working with has a lot more people and a lot more possible categories besides A and B, and I'll have to be doing this a lot in the future, so it would be nice if I could do it all in one fell swoop.
Again, thanks in advance for your help and if you want to direct me any links you think would be helpful, that would be great. Thanks again.
Bookmarks