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.