I have a table
where I would like to split on Group. I want to split Response 1 and Respone 2 but keep them side-by-side. I am using this
What I want, would look like this:
Add a grouping column
Use it as a grouping column in the Split
Which gives you the results
Not quite what I am looking for. The actual solution looks like my third picture.
I believe you will either have to user a script to rearange the columns, or to manually move them.