We have text heavy smartsheet with below columns:
Company Name | Question | Summary Response | Answer 1 | Answer 2 | Answer 3 | Answer 4
The 'company name' column contains various values.
We want to prepare a report for a specific company as below:
Company:
- Question 1
- - Summary Response
- - Answer 1
- - Answer 2
- - Answer 3
- - Answer 4
- Question 2
- - Summary Response
- - Ans....[]
How to accomplish this?
Best,