Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog 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