2 spred sheet- 1 pivot table
Closed
gaurang
-
Jun 22, 2010 at 05:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 22, 2010 at 05:55 AM
venkat1926 Posts 1863 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)
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)
Related:
- 2 spred sheet- 1 pivot table
- Tentacle locker 2 - Download - Adult games
- Tentacle locker 1 - Download - Adult games
- Fnaf 1 download pc - Download - Horror
- Igi 1 download - Download - Shooters
- Fnia 1 apk - Download - Adult games
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 22, 2010 at 05:55 AM
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
choose
multiple consolidation ranges
and then go to next and follow instructions