How to Transform the Data Table as below

[Carrot_WinWin]

Hi Team,

I'm in the middle of processing data. somehow I'm now stuck at below transformation and have no clue.

please help suggest how can I transfer the data as below. really really appreciate for all your kind help. 

[binuacs · Accepted solution]

@Carrot_WinWin One way of doing this

[Carrot_WinWin]

This is Brilliant! Thank you so much.