Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transposing every nth row into a column

WickM
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

6 REPLIES 6
LordNeilLord
15 - Aurora

Hey @WickM 

 

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

 

Capture.PNG

WickM
5 - Atom

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

shevshenko
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.

benakesh
12 - Quasar

Hi @WickM ,

Another option with  'Make columns'   tool  .

benakesh_0-1571934250954.png

iveaghlo
5 - Atom

Benakesh thanks man !

DamLay
5 - Atom

Thank you.

Labels