I am working on a solution for one of our clients where I need to merge a collection with transpose of a row in another collection as explained below:
The two tables on the left represent the two collections that I already have, storing the question data and another one storing the responses to those questions by each user. When admin users log in to the app, they see a gallery of responses (just a title, not the detailed responses) and when they click on a title, the detailed responses from collection 2 will need to be displayed in the format shown in the output collection above. Let me know if this will be feasible or will the solution needs to be designed differently. Thanks in advance.
