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..
How to combine columns in Excel. 1  Select the columns you want to merge in Excel worksheet. 2  Click the Merge Cells Wizard icon. 3  Click on the down arrow next to the Merge selected cells field and select row by row from the drop-down list.ow to merge multiple Excel cells into one. 1  In your Excel worksheet, select the text cells you want to combine into one cell. 2  In the Merge selected cells field, select in one cell. 3  Choose the necessary separator. 4  In the Place the results to field, select the location for the results: 5  The top-left corner.