Subscribe Bookmark RSS Feed

Split Table - Keep Columns Together

Martin

Community Trekker

Joined:

Aug 13, 2013

I have a table

1.jpg

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

 

2.jpg

 

What I want, would look like this:

 

3.jpg

 

Any thoughts?

Thanks

3 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Add a grouping column

split1.PNG

Use it as a grouping column in the Split

split2.PNG

Which gives you the results

split3.PNG

Jim
Martin

Community Trekker

Joined:

Aug 13, 2013

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

 

Martin

txnelson

Super User

Joined:

Jun 22, 2012

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

Jim