How can i extract row values from duplicate column values

hi @Rahul_Unnikrishnan

thank u for your quick response. i’m tried with lot of methods for my requirement but we did’t get proper output. i will share here my excel file. if possible please provide suitable code for my req.

format123.xlsx (10.3 KB)

thanks,
sathwik pindi