Hello, thank you for trying to help me out here. I am conducting a relatively large research project, and could really use some help.
I have a data set in Excel which consists of a list of all the dates that different patients were seen in a clinic. It is arranged like this:
Patient A Date1
Patient A Date2
Patient A Date3
Patient B Date1
Patient B Date2
Patient C Date1
Patient C Date2
Patient C Date3
Patient C Date4
Patient D Date1
What I would like to do, if possible, is have one row per patient, so that it would look like this:
Patient A Date1 Date2 Date3
Patient B Date1 Date2
Patient C Date1 Date2 Date3 Date4
Patient D Date1
What I want to be able to do is sort patients by the first date they were seen. Right now the patient names are organized alphabetically, but I care about the order they were initially seen.
Thank you so much for any help you can give!
Bookmarks