Consolidating data

Hello,   I have a column of data with a number of different medications that I would like to convert to a single term into a new column, any help would be appreciated as I am a newbie.   Eric