Transposing every nth row into a column

[WickM]

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

[LordNeilLord · Accepted solution]

Hey @WickM 

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

[WickM]

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

[shevshenko]

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]

Hi @WickM ,

Another option with  'Make columns'   tool  .

[iveaghlo]

Benakesh thanks man !

[DamLay]

Thank you.