How to Separate sections of questions in one row and make it 2 columns

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

Hi @Brandon_Rinear

Please find the attached xaml file , i developed a workflow as per your requirement
Hope its solves your issue and I also attached output excel
test1.xaml (11.5 KB)
output.xlsx (7.3 KB)
Update me whether you got a desired solution or not
Thanks
Robin S

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.