Hi everyone. I have a large database with a lot of duplicates - however each duplicate contains a different piece of information e.g. one row contains the type of diabetes, another contains date of presentation but for the same patient (same patient number). I would like to merge these rows so that I have one row which includes all of the information for that one person and all of their data is combined.
At the moment I am doing it manually but there must be an easier way as I have over 2500 rows in the real dataset (this is just an example with completely fictional information - not real patients). Thank you in advance for your help.
Bookmarks