Transpose data per month

[Ar13f]

Dear All,

I have the data like below :

and I want the output of the above report is as below: 

[binay2448 · Accepted solution]

Please find solution attached...

[Ar13f]

Dear @binay2448 

thanks for the solution, but what I expect is not the sum ... what I want is that the ticket data is still counted as one data with the same value every month. So, Jason has 2 items from a ticket with a value of 1000 that I want to take is a ticket with a value like below 

[Elias_Nordlinder · Accepted solution]

Hello @Ar13f ,

You can remake @binay2448  version a little bit like this.

I summarized the values first and took the first value for each month/Ticket/Name.

Let me know if this meets your requirements 🙂

//Regards
Elias

[binay2448]

Find attached updated one....

[Ar13f]

Thank you for your solution, @binay2448 and @Elias_Nordlinder .... done ... you're all great