Via -
It is a multi-step process. Start with a helper column, say column D.
In D1, enter something like one of the following:

= A2 & " " & B2 & " " & C2 which will put a space between each of the
entries. You could put any other text between the quotes such as
semi-colon or dash.

If you want the result to look like a bulleted list, you could try the
following...
=CHAR(149) & " " &A2 & CHAR(10) & CHAR(149) & " " & B2 & CHAR(10) &
CHAR(149)& " " & C2

This will make a bullet character at the start of each line and a
carriage return after each line.

Copy the formula down for all of column D then convert to values by
highlighting the column, choosing Edit Copy then Edit Paste Special
Values OK then escape.

Then sort A1 through the bottom row of data in column D by column A.
This will put all rows with a date at the top. All other rows can be
deleted.

- John Michl