Hi I’m facing an issue when i tried to join two sheets into another sheet.
Sheet1:
sheet2:
Expected Output:
when I tried using left join it is giving duplicate values.
Actual:
could someone help me with this?Compare Excel sheets.xlsx (15.2 KB)
Hi
Did we try with other JOIN methods
@Vishwanth_Raya
Try Inner Join
Yes, i have tried using other joins, but still unable to get the expected result.
Yes, i have tried using inner join too, but still didn’t get the expected result.
@Vishwanth_Raya… Learn remaining joins which one suits u that u seeking for… Kindly check given below
Story line of Join Data Table
