merging rows

hi, i have a table like this: number dog cat fish 123 ab     123     cd 123       456 jh     456   ef     and i want result look like this?   number d...