I have a rather large file with millions of entries, so can’t use Excel to create a pivot table to get the desired output.

The file data looks something like:
Name,Date,Count
Simon,2024/04/01,10
Jackie,2024/04/01,13
Donald,2024/04/01,16
Richard,2024/04/02,33
Jackie,2024/04/02,3
Donald,2024/04/02,5
Michael,2024/04/03,18
Jackie,2024/04/03,40
Donald,2024/04/03,50
Richard,2024/04/03,60

The same name does not get repeated daily and new names might pop up for different days.
The output should be in the below format, which will be able to fit into Excel.
Name,2024/04/01,2024/04/02,2024/04/03,Grand Total
Donald,16,5,50,71
Jackie,13,3,40,56
Michael,,,18,18
Richard,,33,60,93
Simon,10,,,10
Grand Total,39,41,168,248

So this is simply a pivot table on the data with the total per name in the end.
Thx

I have googled, but have not been able to get anything useful to assist. I’m not sure where to start here 🙁