Consolidate multiple pieces of cross-tab data instantly
Channel: Efficiency 365 by Dr Nitin
Date: 16/05/2017

Cross-tab is a bad type of input data. Combining multiple cross tab data requires hours (or even days) of manual copy-pasting and complex formulas. Using a powerful but unknown feature of Pivot tables, you can consolidate data in minutes rather than hours. Have a look. By the way, this feature has been available for more than 20 years! For downloading the sample file read this related blog article https://wp.me/p76a9R-4kt