Using bash to format csv data to pivot output

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.