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

Taking report header to columns for each row

Highlighted
Atom

The report I received includes multiple headers throughout the report. The header differentiates contracts but is the only identifier for the rows below and to the next contract. Is there a way that I could transpose the the header (Contract) to the rows below and to the next contact?

Alteryx Certified Partner

The Multi-Row Formula tool should be able to take care of this for you. The formula will rely on the fact that when the header row appears, the other columns are empty. So the logic will say if the other columns are empty, then this is a header row, if it isn't a header row, use the value from the above row. 

 

Once that is complete, I would filter out the original header rows so the data is consistently filled.

 

Check out the attached workflow for an example solution.

Labels