duplicate issue

Hey guys,

I have a table that contains the following columns:
row ID, ambiance grade, score light, score sound, score smell, score interior design.
This was initially 4 different tables containing row ID, ambiance grade, and on of each scores. I manually merged these together, so i now have 6 columns. I merged them basically by appending one on top of each other and adding each score as a new column. The problem is that no row number has more than 1 score that is different from 0 in a single row. So here is an example:

row_ID grades sound_score smell_score light_score ID_score
16 4 2 0 0 0
39 5 3 0 0 0
72 5 2 0 0 0
16 4 0 3 0 0
103 5 3 0 0 0

As you can see for row 16 there exists 2 occurences. I want to merge it so that there is 1 occurrence and has in columns sound the value of 2 and in column smell value of 3.

row_ID grades sound_score smell_score light_score ID_score
16 4 2 3 0 0
39 5 3 0 0 0
72 5 2 0 0 0
103 5 3 0 0 0

There are some occurrences that happen 3 times and some only once. So I want to make it look like the 2nd table.

Sorry my english is not good.

Pl see file.
In L12, copied down.

Formula:

Please Login or Register  to view this content.

In M12 copied to full range.

Formula:

Please Login or Register  to view this content.

Format cells as required.