Horizontal to vertical Formation

[Jaganmohan]

Hi Team,

Could you please help me on below mentioned query.

Attached excel file consist Input data and required output. if possible please explain what are the tool required and logic related stuff.

Thanks in advance.

[Malvim]

Hi @Jaganmohan ,

 this data prep is kind of tricky to achive, but I propose a solution to this case. Hope it can help you.