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..
This is how the Merge Cells button looks like on the Excel Ribbon: To merge two or more rows in your table, proceed with the following 4 steps: 1. Select the rows you want to merge and click on the Merge Cells icon. 2. The Merge Cells dialog window will open with your table or range already selected, as you can see in the screenshot below. In the upper part of the window, you specify three basic things: 1  How you want to join cells.