Split Table - Keep Columns Together

Question

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:

Any thoughts?

Thanks

txnelson · Answer

I believe you will either have to user a script to rearange the columns, or to manually move them.

Martin · Answer

Not quite what I am looking for. The actual solution looks like my third picture.

Martin

txnelson · Answer

Add a grouping column

Use it as a grouping column in the Split

Which gives you the results