Could a pivot table handle this situation?

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
.

Relevant Pages

  • Re: Calculation of weather data help
    ... Perseveer with pivot tables - they're worth it and become a lot easier after ... min temp, rain, sun, wind speed, wind gust and ... pressure (I'm not sure what the final two columns of data on your site are ... In cell P2 enter the formula ...
    (microsoft.public.excel)
  • Creating a graphic from worksheets data: like a "progress" thermo
    ... Is it possible to create graphics from data -- other than pivot ... Specifically, could I somehow create, from data that displays ...
    (microsoft.public.excel.charting)
  • Re: please suggest....pivot table not getting created
    ... > ia mworking on this and unable to resolve a already ... > I am creating a pivot table in a new sheet. ... the new sheet gets created but somehow the ...
    (microsoft.public.excel.misc)
  • please suggest....pivot table not getting created
    ... running macro is giving sucha problem..any help would be ... I am creating a pivot table in a new sheet. ... the new sheet gets created but somehow the ...
    (microsoft.public.excel.misc)
  • Re: Setting Pivottable RowField Width
    ... I have a pivot table in which one row field, "Description", sometimes has a ... and therefore the pivot table comes up with it's column set at ... But, I want to do it through the RowField, somehow... ... could you add another field onto the data that truncates "Description" ...
    (microsoft.public.excel.programming)