
Announcements
I have a collection called csvexport as you can see below
| Question | Response |
Observer | David Hamilton |
Observation Date | 2022.02.25 11:22 |
Customer Number | 100059276 |
Customer Name | Gabrielle Baron |
and I want to transpose this to the one below:
| Question | Observer | Observation Date | Customer Number | Customer Name |
| Response | David Hamilton | 2022.02.25 11:22 | 100059276 | Gabrielle Baron |
Also I took a snippet of the data the number of questions can vary infinitely.
What I did is ?
The reason I am doing this is because they user wants to export this to a csv file with the question on the top row and the answer on the bottom row.
If this is possible to create a collection in this manner then I can sent the collection directly to Power Automate and then create a csv file in one drive.
I would like to do this in Power APPS because otherwise in Power automate to do string manipulation it is a big pain
Thank you so much
Hi @mpezzutti ,
No easy way to do this: https://powerusers.microsoft.com/t5/Building-Power-Apps/Transpose-Data-Collection/m-p/1274129