How to convert table from one form to other form?

[SarahDetroja]

Hello Fellow Experts,

I have a table in the form of "INPUT" format. I want to convert that table in the form of "OUTPUT" format. What is the best way to do that?

Here is the link to the source file and also attached image

There is a Previous thread. Peter has solved a similar problem quite magnificently. However, my programming skill is not good so I can't able to leverage it myself.

Many thanks in advance for your kind help.

Note1: The number of rows can be any number
Note2: The number of columns can be any number
Note3: Assume date format will be consistent
Note4: Here "Email" and "Created Date" has been considered. It would be great to get flexibility so we can use any field as row and column


Regards
Sarah.

 

[SarahDetroja]

Further note:
1. I have highlighted it just for a better understanding.
2. Raw data would be not grouped/sorted like "Email" and "Created Date" so it would appear as it has been entered by users.