Dear all,
I guess my question is fairly easy for someone who knows how to use pivot tables, but it's been keeping me trying unsuccessfully for too long now. Thanks in advance for reading and for your help. I am using Excel 2007 to play with datasets of biological data, and I will try to be as clear as possible in my description. Sorry if this appear a bit simplistic, but that's intended so that I don't confuse everybody.
For each "individual" (in column), I have different "attributes" (in rows). There are a lot of different versions of "attributes" in the whole population of "individuals", so each "attribute" is given a number (qualitative) so that we can compare which "individual" has which version of the "attribute".
My question is: is there a way in Excel (and I suspect this may have to do with pivot tables) to generate lists of "attribute" frequency distribution for each "individual"?
In summary, I have lists like this:
(Note that there are sometimes values in one individual that are not present in another individual, e.g. "3" in "Individual 2")Please Login or Register to view this content.
And my goal is to have something like:
Currently I only manage to do this for single individuals at a time, by putting one column in the "Row labels" field and the same column also in "Values" field of the PivotTable Field List. I don't know how to do this for all my individuals at the same time, the way I do it always seem to give wrong results.Please Login or Register to view this content.
Thanks a lot for your time and your help.
All the best,
G
Bookmarks