Create Pivots data in Alteryx

[AneeshPandey]

Hi All, 

I want help with the following task. 

I have data in this format right now in an excel. I need to calculate the average of value column of all the values in a year and for each maturity. 

Date	Value	Ticker	Maturity	Date	Value	Ticker	Maturity	Date	Value	Ticker	Maturity
1/31/2000	1.xx		Ove	1/31/2000	1.xx	EUR001M Index	1M	1/31/2000	1.xx	EUR002M Index	2M
2/29/2000	1.xy		Ove	2/29/2000	1.xy	EUR001M Index	1M	2/29/2000	1.xy	EUR002M Index	2M

The maturity value goes up till 10YR, 

I want the output in the following format (the column go up to 10Yr and Years till 2023). I want the average of all data (eg. avg of all values for Ove for the year 2000, 2001 and so on)

Year	Ove	1M	2M	3M
2000
2001

Can anyone help with this? Thanks!!

[Raj]

@AneeshPandey 
it will be great if you can provide an excel version of data and required output with values 
will be in better position to help.

[AneeshPandey]

Hi, 

Thanks for the reply. I have attached the data dump and the required output file for reference

[Raj · Accepted solution]

@AneeshPandey 
find the workflow attached
mark solutions done if solved.

[AneeshPandey]

Thank you!!