Hi Dave,

I suppose it could be done, but it would help if you presented a mock-up of your data with a before and after.

With #1, first thought that comes to mind is a Lookup table, but again, without seeing your data I'm just guessing.