Hi there,
I have a field that has some nulls (due to parsing). I want to replace the nulls by looking up the field to the left of it and returning what that field has to replace the null. Does anyone know how I might do that? See below - I want to replace the [Nulls] in rows 4 a
Staff Grade Code | Staff Grade |
61 | Accountant I |
51 | Senior Accountant I |
41 | Manager I |
61 | [Null] |
61 | [Null] |
51 | Senior Accountant I |
51 | Senior Accountant I |
Thanks!
Solved! Go to Solution.
That's not quite what I had in mind - where null in the Staff Grade column, I want to look up the code next to that in the Staff Grade Code column and replace the null with the matching Staff Grade. In other words, I want to replace the nulls for 61 with Accountant I (as shown in row 1).
Thanks Tony, that worked beautifully!