How to make a Pivot showing all unique entries across 2 tables?

[dejavu619]

I know this can be done by pasting one table below another but is there an easier way?

Eg.

Table 1:

ItemList	Value
A	1
B	2
C	3

Table 2:

ItemList	Value
D	10
C	11

Pivot should show:

ItemList	Value
A	1
B	2
C	14
D	10

 

[Sanjeev1976]

Hi,

Press "Alt + D + P" and choose the option multiple consolidation ranges