Forum Discussion

Samuelson Anthony Sylim's avatar
Samuelson Anthony Sylim
Copper Contributor
Apr 06, 2018

Requesting help with MS Excel pivot table solution?

I hope someone can help me with this.   Say, I have two tables in excel: Table1: Tom A Mark B Amy A Paul C Table2: A L A M A N B O B P C Q C R W...
Formulas & Functions
tips and tricks
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 06, 2018

Hi Samuelson,

 

This can be done not in PivotTable but in Get & Transform in Excel 2016 (Aka Power Query add-in in earlier versions of Excel).

 

Please find the attached file to see it.

 

NOTE: If you don't have Excel 2016, you have to download and install the https://www.microsoft.com/en-us/download/details.aspx?id=39379.

 

Hope that help

Haytham

Resources