Consolidate two pivot tables

Hi,

Is there a way to consolidate two pivot tables in Excel 2007?

Thank you!

Not as far as i'm aware mate? but the powers that be may know a way?

may be there is a way to create one pivot table from the following data:

Ppl Type project I % (I) project II % (II)
A type1 project 1 50 project 2 20
B type2 project 2 40
C type1 project 3 30
D type1 project 4 60 project 3 40
E type1 project 1 10
F type2 project 6 20 project 3 20
G type2 project 1 70

Unfortunately I do not have a choice of putting these data in any other view or source.