<title></title> id f1 f2 f3 f4 f5 f6 f7 f8 1 ch1 null ch2 null ch3 null ch4 null 2 n1 0 n1 1 n1 3 n1 6 3 n2 0 n2 2 n2 4 n2 7 4 n3 0 n3 1 n3 5 n3 8 My data looks like in the above table . I want like the below way data....Capital letters are fields in the DB. Need your help pls ch n1 n2 n3 ch1 0 0 0 ch2 1 2 1 ch3 3 4 5 ch4 6 7 8

Hello, And what's the logic to get the result, just by the sample data I don't it? There seems to be no logical relation between the data.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Actually, ch1 &ch2... are chapters. For every chapter there is data associated in the form of n1...I am having table in the above structure shown...Not able to figure it out how to take that out...Any help can be appreciated...