This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.