Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here
SOLVED

Transposing every nth row into a column

Highlighted
5 - Atom

Hello - we are struggling to change the data in the manner depicted below and in the attached file. Any help here would be very much appreciated. Thank you so much for your consideration! -WickM

 

WickM_0-1571929381527.png

Highlighted
Alteryx Certified Partner

Hey @WickM 

 

You can make use of the multirow formula tool here to "group" your data together...

 

Capture.PNG

Highlighted
5 - Atom

@LordNeilLord - thank you so much for quick, helpful response. This worked like a charm.

Highlighted
7 - Meteor

Yes, just a small addition to the shared Workflow by LordNeilLord, you can use a select tool before the output to rename your columns and the leave the ones you want.

Highlighted
12 - Quasar

Hi @WickM ,

Another option with  'Make columns'   tool  .

benakesh_0-1571934250954.png

Highlighted
5 - Atom

Benakesh thanks man !

Labels