Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Taking report header to columns for each row


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.