Dear all,
I have been working with pivot tables quite often but do not know how to 'merge value of header cell for column' if value for 'count of data' is non-blank (or 1). To be more precise I have a pivot-table with a header row including drugs and a header column including the patient id. I want to create a list of all drugs the patient was taking in a separate column.
The number of drugs is around 50 (variable)
The number of patients is anything from 1-50,000.
So for example if patient 1 is taking drugs A, B and Z in the patient's row I get a value of '1' with all the other cells in the row remaining blank. Therefore I want to create another column at the end of the dataset with the list of drugs for each patient. So in this hypothetical example patient 1 would have the new cell in the new column shown as 'A + B + Z'.
In turn I would work out the frequency at which eah drug combination is present.
Can anyone help?
TY
Microsoft Office