SQL（VBA / ADO）命令用于从重复记录中填充NULL字段以及相应的非NULL值

I have a database where several hundred records have been duplicated. However the duplicated information is not the same across all fields. For any two lines, the first line will contain information in some fields while the duplicate line's fields are blank; but then for other fields, the duplicate (second) line will contain information while the first line's fields are blank. For example, it looks like this:I have a database where several hundred records