What's the most efficient way to compare two excel files and point out the differences?
Solved! Go to Solution.
You can consider this:
Or this:
There's an Alteryx macro as well... but can't seem to find it. I'll paste it here once I do find it.
@calvincarr29 I suggest you transpose both data sets then join them together and by doing so you will see all the similarities and differences from the join tool and when your happy you can cross tab the data back out again