I have a set of data in excel where each row has (amongst other things) two values and I want is to generate a sorted list of all pairings.

Example data:

```
Val1 Val2
------------
A B
B A
C A
B C
A B
C A
etc..
```

Example output:

```
Val1 Val2 Count
------------------
A B 2
B A 1
B C 1
C A 2
```

Is there a way to do this without writing VBA code.

**Edit:** I should add that my dataset is growing and I would prefer a solution that would update automatically as new data is entered.