I have a little complex situation here. i have regluar columns and then some hard coded coulumns. First few columns have customer info, Id, and name. next few columns are customized. month1 to month6. under each month a sequence number has coded to "1" represent month one. So if the first digit of the sequence # is 1 then it falls under month1, if first digit is 2 then it falls under mont2 and the same until month6. Now the sequence number appears twice for the same customer, but also want the other sequence numbers under all the months in the same row as well for all different combinations. How is that possible.

Thanks for the idea buddy!!. i'll try it out