sohailausaf353
New Member
- Joined
- Jun 28, 2012
- Messages
- 4
Dear All
I have recently started using pivot table and am not up to speed. Appreciate if I can receive some feed back.
I am using multiple sheets consolidation feature to combine Income statements of 13 different companies into my Pivot Table. However the description of the main headings sometimes differ from each other for eg in one company it could be spelt as "Sale" in another " Sales", or, "Personnel Costs" and " Personnel expenses". All these creates additional lines and should really be clubbed.
What options do I have to standardize these. Should I group these under the right heading, or should I go back to the original sheet and standardise them ( Which I will do eventually)
Thanks
I have recently started using pivot table and am not up to speed. Appreciate if I can receive some feed back.
I am using multiple sheets consolidation feature to combine Income statements of 13 different companies into my Pivot Table. However the description of the main headings sometimes differ from each other for eg in one company it could be spelt as "Sale" in another " Sales", or, "Personnel Costs" and " Personnel expenses". All these creates additional lines and should really be clubbed.
What options do I have to standardize these. Should I group these under the right heading, or should I go back to the original sheet and standardise them ( Which I will do eventually)
Thanks