Consolidate multiple pieces of cross-tab data instantly
2,927 views · Published 16 May 2017 · 9:17 · Indexed 29 September 2026
Channel: Efficiency 365 by Dr Nitin · 2017 · Education
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
More from this channel
-
3:19
Powerpoint Simple to Magical Part 1: Remove background and Animation Demo
-
2:45:46
Office Efficiency Training for Medical Professionals - Session at Nair Hospital Staff Society
-
4:38
SharePoint Part 3 - Sharing documents securely
-
5:02
SharePoint Part 9 - Managing Records and Compliance
-
5:39
SharePoint Part 12 - Branding and Corporate Communication
-
3:23
SharePoint Part 13 - Field Staff Management
-
3:04
Excel Power Query Tutorial: How to clean up data which is split into two rows
-
5:23
Excel Error alert: This is the most dangerous mistake you would be making everyday