@PaigeMiller I understand that the experienced user may not go this route. My case is indeed different.   The goal is to look at my repeated instruments of surveys and look at how the participants are making improvements. It would make much sense to look at this longitudinal data as a single row that have them as the way it was collected. I see the the posts are helpful but still struggling with how I'd want them to display.   Any way thanks for the help.  ... View more

@PaigeMiller For this I need it to be one ID per row. How do I tackle this? ... View more

@r_behata thanks for responding.   Using the code, this is the result I'm currently getting. id x_date1 x_datet2 x_score1 x_score2 x_tpoint dis_date y_tpoint y_score y_date 1 14thfeb 20thfeb 4 5 . . 3 6 1stmarch 2 1stmarch   5 . . . 3 4 15thmarch 3 1stapril 7thapril 6 7 3 . . .     So, the columns for score and date are dependent on how many event per study ID there is.   For example, for StudyID 1 he could have 'n' number of event 'a' or 'n' number of event b, (x_tpoint, y_tpoint and dis_date) is always fixed) so, I have this table id event x_tpoint x_date x_score dis_date y_tpoint y_date y_score 1 a 3 1stjan 4 8       1 a 3 2ndjan 3 8       1 a 3 3rdjan 5 8       1 'n' th a               1 b       8 3 4thjan 6 1 b       8 3 5thjan 7 1 'n' th b                 The events are repeated instruments so ID 1 can have 'n' number of a's and b's.   I want the table below: id event x_tpoint x_date1 x_date2 x_date3 x_date'n' x_score1 x_score2 x_score3 x_score'n'                         I couldn't fit the y_score y_date but the idea is the same.   Really appreciate the help.   ... View more

@ballardw @r_behata That's a really good question. For a given ID, the events are repeated instruments. Meaning, For study ID 1, they could have more than one Event a (in  this example: there's only 2 event a for studyid 1 but there could be more). would the code work if the event "a" or "b" were more for given studyid. for every event they would have dates.   Thank you ... View more