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..
You can combine cells, also known as merging, in order to combine data or improve the appearance of the spreadsheet. Learn how to merge cells in Microsoft Excel. 1. Open your Microsoft Excel document. 2. Type information into the cells. Keep in mind that merging cells can delete data. Only the data in the upper left cell will be kept once the cells have merge. Do not place data in every cell if you plan on merging the cell space.