0

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!

0 Answers0