community
cancel
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

Meteor

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

 

Capture33.JPG

 

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...https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603

 

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

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Alteryx Certified Partner

Hi jacques993,

 

I would suggest something like this.

 

Best,

Fernando V.

Labels