I have a column with IDs that repeat, and I would like to translate the second column to repeat the first value for each unique ID. EXCEPT for when the value is NULL, the value needs to stay NULL. Below is an example of the column I have, and the column I want.
ID HAVE WANT
1 12 12
1 19 12
1 23 12
2 40 40
2 NULL NULL
2 25 40
3 NULL NULL
3 11 11
3 NULL NULL
4 24 24
4 NULL NULL
4 72 24
4 NULL NULL