power query and pivot table for Consolidation

[lishpa]

I have 6 P/L accounts of 6 companies , I want to consolidate it. I use power query and pull all data and merge it. How do I use pivot table to find out if some all P/L accounts are same or if one or two companies have extra elements? Like if co. 4 and 5 have wages , and rent expenses which is not there in co. 1,2 or 3.please help how to use power query to solve this problem.

 

[AlanSidman]

Suggest you load some sample data worksheets. In this manner, we can examine what you have and have completed.

 

[lishpa]

I have 6 P/L accounts of 6 companies , I want to consolidate it. I use power query and pull all data and merge it. How do I use pivot table to find out if some all P/L accounts are same or if one or two companies have extra elements? Like if co. 4 and 5 have wages , and rent expenses which is not there in co. 1,2 or 3.please help how to use power query to solve this problem.