Category: Transform / Advanced

This action fills the empty cells in selected columns by duplicating the value of the last non-empty cell above the empty ones. The cells are filled downwards.

• To fill gaps that may be inherent in an imported outlined or hierarchical data structure.

Example 1: Add the name of the country in the empty cells of the column "Country".

Table: Countries and States/ Provinces

Action parameters:

Select "Country" column.

Result table:

Example 2: Fill in empty cells in "First Name" based on the values in "Last Name" and "Position".

Table: Staff positions

Action parameters:

Fill gaps in "First Name" column
Group by "Last Name" and "Position" columns

Result table:

• "Bob" is filled in where Last Name is "Wilson" and Position is "Admin" (rows 2 and 10).
  
• "Tony" is filled in where Last Name is "Smith" and Position is "Accountant" (row 7). It is not filled in row 9 as Position is "HR Manager" and no previous records have a First Name value for the Last Name = "Smith" and Position = "HR Manager" combination.
  
• No value is filled in row 5 as there is no Last Name = "Wainright" and Position = "Accountant" record prior to the empty cell. (The First Name of "Roger" - row 8 - falls after the empty value - row 5.)
  

• Aggregation of consecutive date ranges (Project; Module: Main; Group: Tab 1; Table: Easymorph Patient Example Data.xlsx;
  Action position: 9)
• Data on multiple rows from Excel file (Project; Module: Main; Group: Group 1; Table: Book1.xlsx; Action position: 2)
• Read Data with two line header (Project; Module: Main; Group: Tab 1; Table: Read, Mark groups; Action position: 6)

• Fill right