Hello Everyone,
Good day!
I need help to transpose excel data. "The data is from SP LIST" . The output should be same with result v2
eg. below
Instead of having result v1. I need it to be result v2. How to obtain this result using power automate?

Hello Everyone,
Good day!
I need help to transpose excel data. "The data is from SP LIST" . The output should be same with result v2
eg. below
Instead of having result v1. I need it to be result v2. How to obtain this result using power automate?
@YamiteKudasai I don't think there is a direct action or way to do this as the data would be dynamic but you can build your excel as Result 1 and then run a script to transpose the data as required.
This video shows how to run scripts in Power Automate, you will have to make a script as per your requirement
https://www.youtube.com/watch?v=il7YS7Dx228
------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.