G
Gabe
I'm making a pivot table to study information about
disease. Each disease has several characteristics like
organism that causes it, symptoms, body part it effects,
ways to detect it, ways to treat it, etc. Sometimes one
category will have multiple entries in it -- for example:
H. influenzae causes flu, there might be one treatment,
one body part if effects, but 2 ways to detect and 5
different symptoms. I want to be able to arrange and sort
my pivot table bases on any single property like the
symptom of coughing, but the only way I know to do this is
to repeat the entry many many times, each time changing
only one variable like:
flu | vaccine | cough
flu | vaccine | fever
flu | Pill X | cough
flu | Pill X | fever
This way I can sort for any quality independently but I
have to have multiple entries. What I'd like is to be
able to only enter one line, like:
flu | vaccine, Pill X | cough, fever
but still be able to sort by things that are treated with
pill X. Does anyone know how to do this?
disease. Each disease has several characteristics like
organism that causes it, symptoms, body part it effects,
ways to detect it, ways to treat it, etc. Sometimes one
category will have multiple entries in it -- for example:
H. influenzae causes flu, there might be one treatment,
one body part if effects, but 2 ways to detect and 5
different symptoms. I want to be able to arrange and sort
my pivot table bases on any single property like the
symptom of coughing, but the only way I know to do this is
to repeat the entry many many times, each time changing
only one variable like:
flu | vaccine | cough
flu | vaccine | fever
flu | Pill X | cough
flu | Pill X | fever
This way I can sort for any quality independently but I
have to have multiple entries. What I'd like is to be
able to only enter one line, like:
flu | vaccine, Pill X | cough, fever
but still be able to sort by things that are treated with
pill X. Does anyone know how to do this?