Edit Script to hide null values

[#1]

I have a table like:

ID     1Rat     2Rat

1          1          -

1          -          2

2          3          -

2          -          5

How can I make them like this using edit script?

ID     1Rat     2Rat

1          1          2

2          3          5

Any help with be appreciated.

[#2]

Actually it works, I forgot the group by clause.

Thanks a lot to all of you.