beginner's problem

Hi, first of all excuse me for my poor English.

I've a table:

CHANGE_NAME | ID | NAME
---------------------------
(empty) | 1 | Kowalski
---------------------------
(empty) | 2 | Nowak
---------------------------
Dubiel | 3 | Szaton
---------------------------
Oles | 4 | Zyłka
---------------------------
(emty) | 4 | Zyłka


but i need something like this - if in field CHANGE_NAME is empty the field NAME is no changing, but if the somebody writed something in this field the field in column NAME is also changed
but not only in one row but in all row's that has the same ID field. So in this case the table must look like this:


ID | NAME
---------------
1 | Kowalski
---------------
2 | Nowak
---------------
3 | Dubiel
---------------
4 | Oles
---------------
4 | Oles

Can somebody help me?

Do you have data in other sheet ? as i understand that if you want write Alex in Change_Name column then in ID Column his ID will be written which will be definitely come from other sheet ???? and in Name Alex will be written .... This is the thing you want ????