However, i notice you are using a resident to do this. If you are loading the data from a SQL query you could nip all this effort from that point and limit your data intake right away.
Also, you aren't really going to get much from this...
Two fields that say the same thing...U_S and status saying Accepted and Accepted????
Please use the match function instead: where match(status,'Accepted','Awaiting Finance','Awaiting Initial Approval',..etc) I think it's much easier to read.
If you're creating a table using 'distinct status' and 'status' then you're just creating a table which holds two columns that have the same values. Unless one of the status fields is from another table, in which case it would explain the nulls.
