Hi,
I have a problem that I need to solve. I have an excel spreadsheet that involves Survey Data and Repeats questions. What I would like it to do is take the data by sections and make it one whole data table. I made an example spreadsheet of my problem.
Example.xlsx (8.7 KB)
If you have any other suggestions for doing this and not merging tables let me know.
I want the results of this to be two columns:
Column 1 (Questions + Comments)
Who
What
Where
Comments
When
Why
How
Comments
Column 2 (Only Other Comments)
Other Comments