I don't think any of really know what your data looks like. That's why you gor different replies - we all tried to solve a different problem.

Can you show us exactly what your data should look like before and after the substitution.