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

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.

[excelisfun]

Good insight! I had not thought that that would be the cause.

[excelisfun]

Yes, there was even a great video response from Power User!!

[MySpreadsheetLab]

Yet again, amazing tip Mike! Many possible variations for this!

[ExcelStrategy]

We discovered another oddity of the Table feature ! The "Double click" does not work ! It behaves as if there was an empty column between the table and the cell :/

[MrSarky]

Hey Mike,

To be honest I loved your formula. Also the VBA solution. This one is just meh for me.

[jeet]

I've tried this formula after making a pivot in outline mode and repeat all line items: =IFERROR(IF(COUNTA(A4:G4)=1, A4, A4&LOOKUP(2, 1/(A4:G4<>""), A4:G4)), "")

[srinivaskandru]

Mike, You are messing up with a table..your tricks will not work here... no here. that works in ranges only... it works only if your columnar data should be baptized into a table.

I always this in my office, but at 2:55, what is the use of that wizard's page fields option...what is the right context to use that?