This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Join and Union tools are your friend for this kind of design.
I've attached a workflow that I think covers all your requirements. Note that I made some assumptions about Data Set 2, and I also have 9 results instead of 8 (your example output did not have a "D" line). I also fixed a typo in Data Set 2 as it was throwing off my results.