I am trying to create a Survey report where each question in the survey is in a column and the answer is in each row.
This would make the report legible where we have the Participant in one column and their answers in the same row
3 answers
Hi Bob, I'm not sure if you were able to generate the report as needed. From what I see, transpose functionality isn't easily available in Salesforce reports, and even advanced tools like Tableau have some limitations in this area. https://help.salesforce.com/s/articleView?id=001472187&type=1
It might be best to export the data and use Excel to achieve the desired format. Alternatively, you could create a custom object and implement batch logic to create new records as needed.
