Hi all,
I think I posted it but somehow I didn't get the ways / steps to build my own.
Currently using Excel 2010 version.
Please refer to the attached.
I got 2 sheets of raw data
Sheet 1 - Case Movement by Order Date
Sheet 2 - Case Movement by Despatch Date.
Reason why I need to combine both sheet and populate into 1 pivot table , is because both sheets needed in order to determine the actual movement.
Both sheet format are the same in terms of header, list of product, etc. (I cut short the list of the data due to size limitation to attach into this forum)
Hence, I need all the expert to show me / guide me steps on how to consolidate these 2 sheet and populate into Pivot Table, and eventually populate into PivotChart for analysis.
I definitely need to learn, because I may need to have another sheet in future (Case Movement by Invoice Date), but let's work out whatever we have.
Appreciate all the expert's guidance urgently.
Thanks
Regards
cks1026
Bookmarks