Could a pivot table handle this situation?

[Bob Manjoney]

I have a spreadsheet with 2 columns: Column 1: Names, Column 2: Dates, where
each Date cell contains a comma-delimited list of dates.

For example:
Name : Dates
Jane Doe : May 1, May 5, May 20
Mary Smith : May 3, May 5, May 6, May 20
Sue Jones : May 1, May 2, May 3, May 4, May 19, May 20

I want to be able to somehow "pivot" this data, so that I wind up with: A
row for each name, a column for each unique date, and a count of how many
times that date was listed for the name.

My first step was to break the original Date column into separate columns
(obvious).

That's about as far as I got - is this something that can be handled with a
Pivot table, and if so, what would the proper steps be?

Any help appreciated!
Bob

 

[Herbert Seidenberg]

Uses reverse Pivot Table:
http://www.freefilehosting.net/download/3g1be