Hi Larry, I think First Method should work for me. I just tested it with dummy data and it worked fine, however I will do it on original database and test on all complex queries, data consistensies and all. thanks you so much for the help. Just to mention, we tried with secoind method but it involved writing query for each of the value column which didn't fit our requirement and was too tedious. Anyways, I will ask any further question if doubt arises. thanks Gnyanendra ... View more