Macro or Lookup to organize/rearrange pivot table information

[coryjacques]

Hello,

I have a pretty obnoxious list to audit and so far the best way to present this is through a pivot table (picture 1).
image1.PNG

This shows all benefit plans grouped by country. I have two of these pivot tables that are similar but not identical and I need to audit them for accuracy. They are completely inaccurate meaning that there is a ton of work to manually go country by country and identify which plans are common between them and which are missing/added.

I am not 100% sure of the best way to go about this, but I was thinking of setting this up in a table similar to the below (picture 2).
Image2.PNG

1) if anyone can recommend a better way to organize this for audit, that would be hugely helpful. The current intention is to do this for both pivot tables into tables but I have a feeling there's a more efficient way to compare.
2) if this seems like a good way, then any help on automating the transition from pivot table to table would be helpful - the original source data is set up like the below which is even more annoying (picture 3, which was taken from the other system source mentioned above to show how obnoxious this was originally set up)
Image3.PNG

[Jim Clayton]

I've done something similar before using slicers. It was pretty helpful. You might give that a shot.

[coryjacques]

I've done something similar before using slicers. It was pretty helpful. You might give that a shot.

I can see that helping a little, but the plans aren't even labeled the same by country and not all countries exist in both tables do I can see that still being a tough one...

[JeteMc]

It may help if you could upload the original source data shown in the screen shot at the bottom of post #1. We may be able to either consolidate Austria's lines of coverage or (probably more helpful) split Belgium's into separate rows.
To upload a sample spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.