Move dates from columns to rows along with hours

[AntlRo]

Hello I think this is an easy one

I have a raw data set with the below columns: The date column has the average time it takes them to complete each tasks. PLease post a yxmd thats easy to use for large data sets theres about 300 rows I'm comparing this too and this is just a short sample :

Name	Team NAme	Tasks	1/1/2022	2/2/2022	3/3/2022
John	Giants	Run	3	1	2
John	Giants	Walk	1	1	1
John	Giants	Play	2	3	2
Chris	JEts	PLay	2	1	1
Chris	JEts	walk	2	2	2
Chris	JEts	Run	1	1	1

I want the output to look like this:

Name	Team NAme	Tasks	Month	Sum of Hours
John	Giants	Run	1/1/2022	6
John	Giants	Walk	2/1/2022	3
John	Giants	Play	3/1/2022	7
Chris	JEts	PLay	1/1/2022	4
Chris	JEts	walk	2/1/2022	6
Chris	JEts	Run	3/1/2022	3

[ShankerV · Accepted solution]

Hi @AntlRo 

Please find the solution attached for you.

As you are expecting the Month column in output, I can still generate that for you.

But the logic is missing, in the input we have 1/1/2022, 2/2/2022 and 3/3/2022.

However in the output the expected is 1/1/2022, 2/1/2022 and 3/1/2022. 

Can you explain the expectation in the month field, so I can generate the output for you as expected.

Many thanks

Shanker V

[AntlRo]

it will just be 3/1.. you can use same dates . I used the dates as an example