Create Pivot Table in Between Data

[unknownymous]

Hello Guys,

Can't find any reference on this so sending this query as you might help me.
What I need is that in the "Check" section, I need to pivot the Name in Row Labels and Date in Values section (Format date based on data).


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Score[/TD]
[TD]Date[/TD]
[TD]Note1[/TD]
[TD]Note2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Ana[/TD]
[TD]10[/TD]
[TD]02/21/2018[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHECK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Score[/TD]
[TD]Date[/TD]
[TD]Note1[/TD]
[TD]Note2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Shy[/TD]
[TD]9[/TD]
[TD]02/21/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Shawn[/TD]
[TD]2[/TD]
[TD]03/21/2018[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Steph[/TD]
[TD]8[/TD]
[TD]04/21/2018[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]

The data may be longer than the example above but the trigger is the "Check" note. Also, I need to rename the pivoted sheet as "PivotData". Also in the pivoted data, the date should be sorted in descending order


Thanks in advance for the help.