Please see the attached file/table. Here is what I have to find a way to do.
1) If the records have the same "Sales Record Number", and the field named "User ID" is blank, COPY the data from "User ID", "Buyer Fullname", "Buyer Phone Number", "Buyer Email", "Buyer Address 1", "Buyer Address 2", "Buyer City", "Buyer State", "Buyer Zip", "Buyer Country", "Payment Method", and "Custom Label" INTO the records with the empty "User ID" that have the same "User ID" as the record being copied from.
2) Delete the record that had the information being copied from. In this example it would be record #2.
3) Cycle through all the records in the table. The example holds just a sampling of the records. There could be many records.
I'd like to keep the data in the original table (until I review the results and them I'll delete them and end up with a new "cleaned" table. This final "cleaned" table would be named "tblCleanedRecords".
I sure hope I explained this one well.
Thanks ahead of time to anyone that will take this one on.