Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Row to column - Header data


Is there any way in alteryx to take a messy cross column header, and add to a new column?




i.e. take Feb-18 and add it to a new column in front of 111 and 222 and Mar-18 in front of 333 for example 

Alteryx Certified Partner

Hey @jacques993


You'll need the multirow formula tool for this job!


Have a look at this guide...


If you need more help, attach some sample data and we can have a look for you :)



Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

Alteryx Certified Partner

Hi jacques993,


I would suggest something like this.



Fernando V.