merge duplicate rows in excel without losing data

When i tried inner join i get only the matching rows from both tables, that means if a PM exist in Planned rev table but not in Actual rev table then i dont get that PM in merged table.And i got the same values as above image I would like to get a merged table like, there will be no data loss, and there will be no data duplicating. I dont understand why i am getting these values. So when i am using full outer join it gets all rows from both tables.īut it giving soo wrong values like as in below imageīut actual no is $1.47. And Some of the PM's Exists in planned rev,not in actual rev.

I have two tables, one is Planned Revenue and another one is Actual Revenue.I would like to merge these two tables based on PM(For ex) using Full outer join.īut I have the tables data like Some of the PM's having Planned Rev but not Actual Rev, And some of the PM's having Actual Rev,but not Planned Rev. I have been searching and trying to findout a perfect solution for merging two tables without missing any data from both tables and without duplicating the values but i could'nt get anywhere.

Merge duplicate rows in excel without losing data