Transpose excel Rows data into column

[ranaprathap928 (Rana reddy)]

Hi Everyone, I’m facing an issue in transposing excel rows data into columns.
i need to read excel rows and need to update them in columns.

i’m attaching my input excel for information.

can anyone help me how to solve this

Input.xlsx (10.5 KB)

in this excel i mentioned my input and my required OUTPUT

[kl_kl]

Please try this , let me know if you have any doubts
Thank you
ui.xaml (17.9 KB)

[Jobin_Joy]

Hi @ranaprathap928

Can you please try this?

Code:
DTTransponse.zip (18.2 KB)

Hope this will help you. Thank you.

[ranaprathap928 (Rana reddy)]

Thanks @kl_kl , this solution is working as per my requirement. Thank you so much for the solution.

[ranaprathap928 (Rana reddy)]

Hi @Jobin_Joy this is working but it’s not giving my exact output. Thanks for your solution, this also useful for me in other format. Thank you.