I deal with a two column table where I have to match data from two sources. The first column contains names of persons for whom, service is provided. The second, persons who are billed. My job is to match them at the end of day and find out descripancy, if any. Is there a way to automate this, so I just have a list of mismatched names with couple of clicks. Regards.
|column 1| column2|
|--------|--------|
| abc | xyz |
| xyz | abc |
| CSR | CSR |
Expected result:
|column 1| column2|
|--------|--------|
| abc | xyz |
| xyz | abc |