Pivot Table
Yes, the dates with the same date will be grouped in to One and show as a single row.