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..
Report Abuse. 1  Merge Two Columns In Excel. 2  Combine 2 Columns In Excel. 3  This Site Might Help You.  It is called 1  Concatenate. Not only columns but you can merge multiple sheets or files in a shot.  1. create a new column next to the 2 columns you want to merge. 2. In the top data cell type: =CONCATENATE(A1, ,B1) 3. drag down the fill button down next to the rest of the data. Note after its merged the data will be seperated by a space but you can put any symbol you want in between the two  .