Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Описание: Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download Excel File: http://people.highline.edu/mgirvin/Ex...
Re-do of video: Mr Excel & excelisfun Trick 134:
1. Join Product name and Sub Product name from a two dimensional table by using the Excel 2003 PivotTable Wizard (keyboard = Alt, D, P) and Multiple Consolidation Ranges and the fact that you can double click the Grand Total cell to get back to the transactional data set, then create a text formula to join product and sub product.