For example, if the data looks like the following, how do I make it so that each follow up date comes in a new column?
Unique ID Date of Screening Date of Follow up
1 10-Sep 12-Sep
1 10-Sep 15-Sep
1 10-Sep 20-Sep
2 12-Dec 24-Dec
2 12-Dec 30-Dec
In this scenario I would like the dataset to look something like this:
Unique ID Date of Screening Date of Follow up 1 Date of Follow up2 Date of Follow up3
1 10-Sep 12-Sep 15-Sep 20-Sep
2 12-Dec 24-Dec 30-Dec
what code can I use for this?