I would like to count all rows with the same values in two columns,
| Col 1 | Col 2 |
|---|---|
| Apple | Banana |
| Apple | Orange |
| Orange | Banana |
| Orange | Banana |
| Apple | Orange |
| Banana | Orange |
| Apple | Orange |
I'm looking for a method that produces something like this:
| Count | Col 1 | Col 2 |
|---|---|---|
| 3 | Apple | Orange |
| 1 | Apple | Banana |
| 2 | Orange | Banana |
| 1 | Banana | Orange |
Thanks in advance!