convert row to column
914567Jul 25 2012 — edited Jul 25 2012I am having table data as
SNO Value1 Value2
1 1:2:3:4 a:b:c:d
2 5:4:3:2 w:x:y:z
i want to convert it to
SNO Value1 Value2
1 1 a
1 2 b
1 3 c
1 4 d
2 5 e
2 4 f
2 3 g
2 2 h
could anyone please help me out inthis