Hello! I am working with health data in the following format: ID = Patient ID Date = Date of Procedure DocIDProcedure1 = the ID number of the doctor that performed the 1st procedure DocIDProcedure2 = the ID number of the doctor that performed the 2nd procedure DocIDProcedure3 = the ID number of the doctor that performed the 3rd procedure This is an abbreviated list. I have a list of over 50 procedures for each row. The data looks like the following:   ID          Date                   DocIDProcedure1         DocIDProcedure2            DocIDProcedure3 1            Nov112020               1234            1            Nov112020                                                        3456            1            Nov112020                                                                                                 7890 2            Dec032020                                                                                                 2465 2            Dec032020                                                        1170   What I would like to do: For each ID/Date combination, I would like to back and forward fill the doctor IDs so that they show up on each line (for the same ID and date).   So, I would like the above dataset to look like the following: ID          Date                   DocIDProcedure1         DocIDProcedure2            DocIDProcedure3 1            Nov112020               1234                              3456                                   7890 1            Nov112020               1234                              3456                                   7890 1            Nov112020               1234                              3456                                   7890 2            Dec032020                                                     1170                                   2465 2            Dec032020                                                     1170                                   2465   This is really stumping me. Any help would be greatly appreciated!   Mikki ... View more