- Joined
- Dec 22, 2014
- Messages
- 1
- Reaction score
- 0
Hello All
as i wrote in the title,
I have tow sheets with different data, and different Headers ! and i want to make a pivot table to summarize the data from the both of them !
as EXAMPLE
sheet 1 has the headers :
CONTRACT_LOCATION, QUOTE_ID, ACCOUNT_NAME, QUOTE_REGION.
and sheet2 has the headers
QUOTE_ID, SERVICE_CATALOG, SERVICE_NAME, SERVICE_LIST_PRICE.
the Quote_ID is the common field between the tow sheets , and all others is different!
i could do this in Excel 2013 using the new option Data Model , but i need to do it in 2007 as well ,
any help
thanks in advance ,
Regards
as i wrote in the title,
I have tow sheets with different data, and different Headers ! and i want to make a pivot table to summarize the data from the both of them !
as EXAMPLE
sheet 1 has the headers :
CONTRACT_LOCATION, QUOTE_ID, ACCOUNT_NAME, QUOTE_REGION.
and sheet2 has the headers
QUOTE_ID, SERVICE_CATALOG, SERVICE_NAME, SERVICE_LIST_PRICE.
the Quote_ID is the common field between the tow sheets , and all others is different!
i could do this in Excel 2013 using the new option Data Model , but i need to do it in 2007 as well ,
any help
thanks in advance ,
Regards