Can you consolidate data in this way?

[signal]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Say I have Sheet1:

Name Amount1 Amount2
A 1 2
B 3 4
C 5 6

And Sheet2

Name Amount1 Amount2
A 1 1
B 1 1
D 3 3

I want to combine them to produce:

Name Amount1 Amount2
A 2 3
B 4 5
C 5 6
D 3 3

I am not really looking for a pivot table, I am looking to use some sort of consolidate function, but consolidate doesn't seem to do what I want, I tried it and it blanked out my name column for some reason.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Say I have Sheet1:

Name Amount1 Amount2
A 1 2
B 3 4
C 5 6

And Sheet2

Name Amount1 Amount2
A 1 1
B 1 1
D 3 3

I want to combine them to produce:

Name Amount1 Amount2
A 2 3
B 4 5
C 5 6
D 3 3

I am not really looking for a pivot table, I am looking to use some sort of
consolidate function, but consolidate doesn't seem to do what I want, I tried
it and it blanked out my name column for some reason.

There are a bunch of ways to do this. Do you need to keep the original
values, or do you just want a one time consolidated result?

One way:
- Make a copy of sheet 1. Name it summary or something.
- copy the data from sheet 2 below the data from sheet 1 on the summary
sheet.
- repeat for as many sheets as needed.
- sort the summary sheet on column A
- On the Data menu, select sub totals