Hi all, Have id Date Subject 1 Subject 2 1 July 10, 2020 Math Science 1 July 10, 2020 . Science 1 July 10, 2020 . Science 2 Feb 10, 2020 History Physics 2 Feb 10, 2020 Biology Physics 3 Jun 24, 2020 . Math 3 Jun 24, 2020 . Math 4 May 7, 2020 History Math 4 May 7, 2020 English Math 4 May 7, 2020 . Math 5 Feb 2, 2020 . French 5 Feb 2, 2020 . French Want id Date Subject 1 July 10, 2020 Math 2 Feb 10, 2020 History 2 Feb 10, 2020 Biology 3 Jun 24, 2020 Math 4 May 7, 2020 History 4 May 7, 2020 English 5 Feb 2, 2020 French So, basically, I want to replace subject 1 with subject 2 only when there is no subject mentioned for each student id. Any help is appreciated.
... View more