I have data in 2 different worksheets that I want to combine into one. Each sheet has an id# column and most of the id#s have a matching id# in the other sheet. How do I combine the sheets so the data with the matching id#s appear in the same row. The sort function will not work because not all id#s have a match in the other sheet.