I have a (huge) Excel 2007 workbook with three worksheets, representing one of three major astronomical catalogs (I need a large dataset for another project I'm working on). Due to the size, I can't do this manually.
I need to consolidate the three worksheets into a single worksheet, where each worksheet may or may not have matching data in one of the other worksheets. Each sheet has the same headers, in the same order.
The first 6 columns contain the names of the object from the catalog:
HDNAME GCNAME SAONAME BDNAME HIPNAME GLIESENAME
Each of these columns may or may not be populated, and may be duplicated in other of the other sheets (especially HDNAME and BDNAME).
Can someone suggest how to consolidate these items into a single worksheet, eliminating duplicates, etc?