I think that helping you with the best way to solve this is probably beyond the scope of assistance that this forum can provide. There are a lot of dependancies on how the data might have been coded.

Have you considered making a copy of your data and playing around with different approaches to see which one works best for you?