Please find the attached file below (excel as well as tableau workbook). Please refer to the below screenshot and confirm the output.
I have created 3 separate sheets in excel and joined them in below way.
Sheet 1 and Sheet 3
Sheet 1 and Sheet 2
Then pull the required columns on the sheet.
let me know if any query about this. Don't forget to refer to the excel.
Thanks and Regards,