Skip to main content
1
Add a Custom Transforms step onto your flow
2
In the Instructions box, write something like:
Please move the header row down and include as part of the data set. Please provide new column headers by numbering the columns.

​
Option 2: Construct a new header step-by-step

1
Use a Limit rows step to keep the first 0 rows so the data returns blank, except for the headers
2
Then attach an Add Row Numbers step and name the column “First Row Data”
3
After that, use a Flip table step, so it turns into one column with many rows (the number equal to the number of columns).
4
Subsequently, add another Add Row Numbers step to number your new columns. Title this column “New Column Headers.”
5
After that, Flip table step once more.
6
Then, you can use an Edit Columns step to rename the numbered columns as you want.
7
Finally, you use a Stack tables step to combine your two data sources. The first Input should be your headers data (coming from the Edit Columns step). The second input should be your initial data, i.e. an arrow coming from the step prior to the Limit Rows step. It is important to note that you must uncheck the “Match up data by column names.”
Last modified on February 26, 2026