Copy Date to a column with Advanced Filterunique records only.
Name this column Date2
Copy unique Name(s) to a row and name row Name2
Arrange Date2 and Name2 to enclose a 2D Table.
Fill Table with this formula:
=SUMPRODUCT((Date=Date2 R)*(Name=Name2 C)*Data)