To cross-reference between spreadsheets, you must identify cells using extended addresses. These extended references specify the cell's sheet as well as its column and row.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.