Create a new column based on distinct result

Hi,   Good day.   I need some help to get an accurate audit result from a given audited data. But first, let me share to your our audit process and give you samples. See details as follows:   1...