Hi,
One approach you could take is the following.
First sort the A & B columns by date in ascending order, and make sure the two columns of data start in row 2. Now in C2 enter
and in D2
copy these formula down the whole set of data, and then Copycolumns B:C and Paste Special values.
Now put some column labels in row 1, A,B,C & D will do, and Autofilter the table picking the value '1' in column D. These will be all the rows, one for every day, and column C will contain all the events, single or multiple for that day separated by commas.
Now all you need do is copy columns A:C of the filtered rows somewhere else, delete column B and do a Data 'Text To Columns' operation on column B using the comma as a delimiter.
HTH
Bookmarks