Pause and guess · 37 sec
They sorted the CSV. Did anything change?
Match CSV records by their unique ID to compare identical data in a different order.
Read the transcript
Someone sorted the export. Did a single amount change? Pause and follow the record IDs. Compared by position, the first row looks completely different. Alice is now in row two of the data. In CSV and TSV options, set Match rows by to Key column. Enter Record ID. Every row needs its own unique, nonblank ID. Compare again. All three records match. The rows moved, and every amount stayed with its owner.