Transpose excel Rows data into column

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

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

1 Like

Hi @ranaprathap928

Can you please try this?

Code: (18.2 KB)

Hope this will help you. Thank you.

1 Like

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

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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.