Hello,
I have a set of data that I need to add a column header (title) for the first column and then fill down the rows.
I wasn't sure if there are different rules for this when the data does not start on the first row & column?
Original Data
Desired Output
Solved! Go to Solution.
Hi, here is how you can get the desired output by following the below steps. I have also attached the workflow for your reference.
Step 1: Skip 1st two rows that are not required using sample tool
Step 2: Use Dynamic Rename tool to make your first row as header with the below configuration
Step 3: Use Multi-row formula to auto fill values. You can use the below configuration for each column you want to auto-fill/multi-fill for:
Here is the snippet of completed workflow with the desired output: