This has me stumped.
if you have data that looks like
How do I get it to
I am trying to put 2 pivot tables next to each other, so I can compare the two sheets, but when I do it naturally they misalign. the sheets have multiple data under each number, which is what I want to match by (the 1, 2, 3, 4, 5 here) but the data that accompanies these numbers (here, the states and names), don't match up between the two sheets so I want to see differences.
if data looks like example 2, with "eric" appearing both under 1, and 2 - is there a way to make it populate with the correct $ amount for each? instead of populating the pay with the first instance of "eric" (under 1)?