Combining two dataset - common column and rows

[ilovecoding]

Im trying to add similar to below 2 dataset where end result should be to including all rows i.e. all students and combine (sum 2 sems) their marks into 1 (wherever applicable). Not getting the desired result with Join function, may be im missing something, pls assist.  

[ShankerV · Accepted solution]

Hi @ilovecoding 

One way of doing this.

Many thanks

Shanker V