Pivot from multiple sheets

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

hi,

i have the below data and i need to make pivot from multiple sheets.i have
tried to make by selecting multiple consolidation ranges, bbut it is not
giving me the flexibility that is available while doing in a single sheet...
Month Processor Process
Jan Mark Manual
Feb Henry Automatic
Jan Chad Automatic
Mar Mark Automatic
Apr Mark Manual
Jan Chad Automatic
Jan Henry Manual
Apr Henry Manual
Feb Mark Automatic
Mar Chad Manual
Jan Mark Automatic
it gives the belowformat...
Row Process Processor Grand Total
Jan 15 15 30
Feb 6 6 12
Mar 6 6 12
Apr 6 6 12
Total 33 33 66

where as i need the below format...is it possible in making pivot from
multiple sheets
Process Month Chad Henry Mark Grand Total
Automatic Jan 2 1 3
Feb 1 1 2
Mar 1 1
Manual Jan 1 1 2
Mar 1 1
Apr 1 1 2
Total 3 3 5 11
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot from multiple sheets 0
Summing a non continuous range 7
table lookup 5
Sum with 3 conditions 9
Copying formula vertically, to pick up horizontal cell values 3
Countifs or a pivot 1
Sum multiple colums of data 5
Specify columns to add for months MTD Diff 3

Top