Sorting like "dynamic table"

[anteportam]

Hello,

I have a problem and I need your expertise.

I have a series of data like and I would like to sort them as a "dynamic table in excel", see the snippets below.

My data:

How I need it.

Is there any way to do it? I have tried with Summarize and Transpose tools, but the results aren't what I needed.

Thanks

P.S.

Sorry if I had chosen the wrong tags.

[ShankerV]

Hi @anteportam 

Can you please share the input in the copy paste format instead of screenshot please.

Or in excel sheet also.

Many thanks

Shanker V

[anteportam]

Here is the excel