I am keying some data and one question from the data set supports multiple answers. As best I can tell, I have the choice of keying this as a delimited column, e.g.

```
Answer1
------
A
A,B
C
B,D
```

Or, I can key it as multiple columns:

```
Answer1 Answer1
------- -------
A
A B
C
B D
```

Either way, I need to be able to summarize this data using a pivot table, but I'm not sure how to go about this? Suggestions?

The resulting pivot table should look something like:

```
Answer1 Count
------- -----
A 2
B 2
C 1
D 1
```