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

[MatthewO]

@AntlRo attached is a sample of how you may be able to approach this. I don't follow how your output is being calculated, and the example doesn't achieve the same results, but with some modifications it may get you there. If you can clarify the calculation for the Hours field, happy to take another pass.

[flying008]

Hi, @AntlRo 

What's your field [Month] ?

[AntlRo]

ITs just a sum of the date rows which are hours , I just edited my post. Basically Each date column are hours ( example 1 hour, 2 hours etc))

[AntlRo]

ITs just a sum of the date rows which are hours , I just edited my post. Basically Each date column are hours ( example 1 hour, 2 hours etc))

[flying008]

Hi,@AntlRo 

The [Hour] is get, but what logic about field [Month] ?

[AntlRo]

Basically you create a new column and call it what ever you want, but in this case we will call it month. 

[flying008]

Hi, @AntlRo 

So, like this ?

[AntlRo]

can you post the yxmd so I can compare 

[flying008]

Hi,@AntlRo 

I can't  upload any files, so give you a  gif here: