Data compare, primary/secondary key columns

[Michael Bulgrien]

I have a pair of spreadsheets that I need to compare. There are three columns. Column 3 is the primary key, and column 1 is the secondary key. In other words, I need the compare to be sorted by column 3 and sub-sorted by column 1. The values in both columns 3 and 1 must match (except for whitespace and character case differences) for the rows to be aligned. Column 2 is a normal column to be compared when the two key fields match.

How do I get the data compare to sort by column 3 first then by column 1?

Edit: Never mind... I figured out how to go into Session Settings and float column 3 to the top.