So I have a table of records. Each row is a record that contains 5 columns of items. I created these records manually, but now i need to identify any records (rows) that contain the same values across the 5 columns. See below: the first and third records are duplicates because they contain the same 5 value regardless of which column they fall in.
<tbody>
</tbody>
A | B | C | D | E | F | |
1 | ITEM | ITEM | ITEM | ITEM | ITEM | DUP? |
2 | apple | orange | grape | dog | cat | Y |
3 | bug | apple | orange | cat | dog | N |
4 | orange | apple | dog | cat | grape | Y |
5 | dog | bird | banana | cat | grape | N |
<tbody>
</tbody>