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). ID Name Score Date Note1 Note2 1 Ana 10 02/21/2018 - - CHECK ID Name Score Date Note1 Note2 5 Shy 9 02/21/2018 4 Shawn 2 03/21/2018 - - 6 Steph 8 04/21/2018 - - 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Create Pivot Table in Between Data

Thread starter unknownymous
Start date Apr 2, 2018
Tags

date excel excel & macro pivot vba

unknownymous

Board Regular

Apr 2, 2018

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).

ID	Name	Score	Date	Note1	Note2
1	Ana	10	02/21/2018	-	-

CHECK
ID	Name	Score	Date	Note1	Note2
5	Shy	9	02/21/2018
4	Shawn	2	03/21/2018	-	-
6	Steph	8	04/21/2018	-	-

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.