Sort and combine records/rows from two sheets.

**Tinman88** · 10-27-2009, 01:37 PM

I've just been handed an Excel workbook with two sheets of data, with one being the first 65000 records, and the next being the continuation (another ~35000). The user would like to be able to sort the data and combine it so that records with a given value in one column could appear on the same sheet, and he could get a total for a couple values in other columns for each of the sort values. I'm sure there's a fairly easy solution for this using one of the lookup functions or something, but I'm pretty rusty on my fancy Excel junk.

TIA

**Leith Ross** · 10-27-2009, 02:40 PM

Hello Tinman88,

You should have included a sample of the data. Pretty difficult to answer a question about combining records if you don't know what the records look like.

**Tinman88** · 10-27-2009, 02:51 PM

There are privacy issues, but I suppose I could edit it. I think my problem is solved anyway: I'm told that in Excel 2007 the same limitations do not apply, so all I have to do is save it as a .xlsx file and copy and paste, then sort.