I need to merge two data sheets in excel. Each worksheet has a common column, the number, but some numbers are on one page but not the other and some are on both pages. Additionally, all of the headers on worksheet one are different than worksheet two. I need to merge the two sheets together such that worksheet two's columns are at the end of worksheet one and so that each number in column a is not repeated in any row.
I've done a good search of the rules, and haven't found any rules to stop me linking to an excel file i've uploaded with a mock up of the answer.
I have 1-->8 on Sheet1; and 1,2, and 5-->10 on Sheet2.
Here I can easily just put 1-->10 on sheet3 (though actually did copy and paste all the numbers from Sheet1 & Sheet2, into Sheet3, then did a Remove duplicates as i suggested in my comment).
Then with alot of vlookup() formulas, I merged all the cells