Hi all,

I got 2 sheet source of data, which it contain the details of sales order and cancelled order, both sheet have different details, different header / field.
How can I possible combine these 2 sheet data into 1 pivot table.

I'm currently using Excel 2010.

Appreciate your help.

Thanks

Regards
cks1026