Can be done. I will take this up. Need clarification on something. In your sample file, there are subject lines that start with RE: and FW:

If we take out these characters, your pivot table will look lot more clear and sensible. Can you do that, and then check if we can work on that data? Also, after you do that, can you put in the expected output (for a few samples).

Also, the original macro needs to pick the SMTP address of the sender.