my (@dates, %msc_sequences, %date_totals);

<INFILE>; # skip first line
while( <INFILE> ) {
    chomp;
    # use variable names as clearer than hash futher down
    my ($msc_name, $chunum, $date, $count_per_date) = split /\s*,\s*/;

    push @dates, $date;
    $date_totals{$date} += $count_per_date;
    $msc_sequences{$msc_name}->{$date} = $count_per_date;
}

print join(',', 'MSC_name', @dates) . "\n";

foreach my $msc_name (keys %msc_sequences) {
    my %tmp = %{$msc_sequences{$msc_name}};
    print join(',', $msc_name, @tmp{@dates}) . "\n";
}

print join(',', 'Total_cf_produced', @date_totals{@dates}) . "\n";