community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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