In the attached file, I am attempting to create two separate tables from the source table:
1. Duplicate information - but on different rows (Green Rows)
2, Same information (Pink Rows)
In 1., please ignore that the field sequence (i.e. 1 or 2) exists, and examine only the information in the fields. In this case, the information is the same, only that the information changes from the first part of the row to the second part of the row and vice versa in rows 1 and 4.
In rows 2. and 3., please note that the information contained is not the same.