sorting addresses via hidden columns

amosglenn

I've got a table of contact information. I'd like to have one column that can be used to sort mailing addresses. To do this, I've got one column called "Mailing Address" with the complete address, and another four hidden columns each with a part of the address: (1) "street address", (2) "city", (3) "state", and (4) "zip code".

When the user clicks the "Mailing Address" column, I'd like the addresses to be sorting first by the "zip code" hidden column, then by the "state" hidden column, then by the "city" hidden column, and last by the "street address" hidden column.

It seems easy to sort a visible column by a single hidden column, but can we sort by multiple hidden columns?

Thanks!