Hi everyone! My question is a bit simpler than the subject makes it sound, but I can't figure it out. Here's an idea of what I have: ID VisiteDate DiagnosticDate 001 08/25/2021 06/03/2013 001 08/25/2022 001 08/25/2023 002 06/02/2022 05/06/2020 002 06/02/2023 003 02/23/2021 04/04/2018 003 02/23/2022 003 02/23/2023 004 05/14/2021 04/27/2001 004 05/14/2022 004 05/14/2023 And here's what I would like to have: ID VisiteDate DiagnosticDate 001 08/25/2021 06/03/2013 001 08/25/2022 06/03/2013 001 08/25/2023 06/03/2013 002 06/02/2022 05/06/2020 002 06/02/2023 05/06/2020 003 02/23/2021 04/04/2018 003 02/23/2022 04/04/2018 003 02/23/2023 04/04/2018 004 05/14/2021 04/27/2001 004 05/14/2022 04/27/2001 004 05/14/2023 04/27/2001 Thanks in advance for the help!
... View more