You’re offline. This is a read only version of the page.
Hi,
Is it possible to read an Excel by rows and then transpose it and add as column answers in another Excel sheet?
The reason is because it is easier for the user to type in their answers as rows but then for me to use is as data, it is easier as a column format.
Please see the images below.
So first, I am trying to have users answer questions using the format below:
And then using MS FLOW to copy the data and add it as a row in another Excel sheet like shown below:
Thanks!
How would this work if part of the question rows are missing?
From:
Question1 : Answer1
Question2 : Answer2
Question4 : Answer4
Question6 : Answer6
To:
Question1|Question2|Question3|Question4|Question5|Question6
Answer1 |Answer2 | |Answer4 | |Answer6
Thank you
Hi @Json123 :
I have responded in this thread:
Get answers by rows but then paste it as columns - Power Platform Community (microsoft.com)
Hope my solution helps.
Best Regards,
Bof
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (