Q’s now got a great feature for automatically categorizing geographic data. It is run by selecting a variable and then Automate > Browse Online Library > Create New Variables  > By Geography.

The example below shows Australian postcodes converted into Local Government Areas and States.

Author: Matilda Sarah