Excel: Enhance Your Excel Skills with One-to-Many Lookup
and then another table to list the codes. Like: lookup_attribute (attribute_id, attribute_name) lookup_value (attribute_id, value_id, value_text) Then the first table has records like. 1, 'Gender' 2, 'Marital Status' 3, 'Education' etc. ...