2 spred sheet- 1 pivot table

Closed
gaurang - Jun 22, 2010 at 05:41 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 22, 2010 at 05:55 AM
Hello,

I have 2 sheets in a file and both have some similar data in columns and some colums are diferent in both sheets , now i want to manage both spred sheets data in 1 pivot table which i cant do it anyhow , i need few columns from each spred sheet in 1 pivot table

can anyone please advise how to do it ( sorry if my question is not clear enough)



1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 22, 2010 at 05:55 AM
in the first window that comes up after clicking data-pivot table

choose

multiple consolidation ranges

and then go to next and follow instructions
0