I have following rows. (int, int, int, int) X, A, 1, 15 X, A, 2, 13 X, A, 3, 11 ...... Y, B, 1, 14 Y, B, 2, 10, .... Z, C, 1, 30 ...
I want to merge them to X, A, 15, 13, 11 Y, B, 14, 10, 0 Z, C, 30, 0, 0 Third field/column will vary from 1-10, if row doesn't exist corresponding entry in new modified data will be 0. Please help. Ajay Dubey <http://www.google.com/imgres?imgurl=http://admissions.iiit.ac.in/logo_name.gif&imgrefurl=http://admissions.iiit.ac.in/admission_procedure.php&usg=__9ccHkzRxJdf9UV-7HNUbLjy0KYQ=&h=91&w=324&sz=19&hl=en&start=18&sig2=W2CiCzBOQyPJFhCggrbDSA&zoom=1&tbnid=5zVpQ8aNlkzftM:&tbnh=63&tbnw=226&ei=qP53TLSJDsnQccn7qOcF&prev=/images%3Fq%3DIIIT-H%26hl%3Den%26sa%3DX%26prmdo%3D1%26biw%3D1307%26bih%3D576%26tbs%3Disch:1&itbs=1&iact=hc&vpx=152&vpy=322&dur=876&hovh=72&hovw=259&tx=164&ty=45&oei=o_53TOanCYfKcIyU-eIF&esq=2&page=2&ndsp=19&ved=1t:429,r:13,s:18>
