You put the official county code in one column, and extract the state for the other column.