University of Maryland--College Park has a total undergraduate enrollment of 28,472, with a gender distribution of 53 percent male students and 47 percent female students. At this school, 40 percent of the students live in college-owned, -operated or -affiliated housing and 60 percent of students live off campus.
Consolidate Spreadsheets. First, open Excel and open both of the files you're looking to merge. Make sure the column headers are the same. Now open a new spreadsheet, which will be the destination for your merged data. From this new spreadsheet, click on the Data tab and click on Consolidate..
Additional options provided by the Merge Tables Wizard let you combine data from two Excel worksheets exactly in accordance with your needs. 1  You can update only empty cells in your main table. Check this option if you don't want to overwrite existing values in your main table. Update the master table value only if the corresponding cell from the lookup table contains data. Check this option, if you want to ignore empty cells in the lookup table.