Manually enter data into a mapping table

I want to create a mapping table to map each distinct value of a column in a query with a more general category that I will specify manually. So I would get the list of distinct values with the DISTI...