Thread: Merging two Pivot Tables

Hello Guys

I got two Pivot tables and i need to merge them to one.


Count of TS_NAME Count of TS_NAME
ACTUAL_EXECUTION_DATE Total START_DATE Total
23/02/2010 12 12 24
26/02/2010 8 2/03/2010 24
1/03/2010 2 3/03/2010 32
2/03/2010 32 4/03/2010 33
3/03/2010 42 5/03/2010 33
4/03/2010 19 9/03/2010 46
5/03/2010 31 10/03/2010 40
9/03/2010 28 11/03/2010 34
10/03/2010 63 12/03/2010 42
11/03/2010 32 15/03/2010 40
12/03/2010 20 16/03/2010 115
15/03/2010 33 17/03/2010 66
16/03/2010 35 18/03/2010 51
17/03/2010 42 19/03/2010 37
18/03/2010 6 22/03/2010 1
19/03/2010 6 23/03/2010 3
22/03/2010 22 27/03/2010 3
23/03/2010 11 28/03/2010 26
24/03/2010 25 30/03/2010 1
25/03/2010 31 31/03/2010 2
(blank) 281 (blank) 128
Grand Total 781 Grand Total 781


i need in this format.

Date Total Actual exec Total start
23/02/2010 12 0
24/02/2010 0 0
25/02/2010 0 0
26/02/2010 8 0
27/02/2010 0 0
28/02/2010 0 0
1/03/2010 2 24
2/03/2010 32 24
3/03/2010 42 32

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!