Multiple Fill values (not from first line)

tiverson

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

Fill data.xlsx

Medha31

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:

Multi_fill_solution.yxmd