First thank you for this Code, it is working. But now I have one more Problem. My Table is looking like this: ID TUMOR_ID Date of Diagnosis OP Date 1 1 02.01.2017 02.01.2017 2 1 05.09.2015 07.09.2015 3 1 06.02.2019 09.03.2019 4 1 08.09.2014 08.09.2014 4 2 25.10.2015 30.10.2015 5 1 06.11.2020 01.01.2020 5 1 06.11.2020 01.02.2020 and I want the new Table like this: ID TUMOR_ID Date of Diagnosis OP Date 1 1 02.01.2017 02.01.2017 2 1 05.09.2015 07.09.2015 3 1 06.02.2019 09.03.2019 4 1 08.09.2014 08.09.2014 4 2 25.10.2015 30.10.2015 5 1 06.11.2020 With the Code before, I become Deleted also the ID Numer 4 , so it reduce me my Table. I want for the ID Number both Tumor_IDs. Thanks for you Help!!!
... View more