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.

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

Fill gaps in columns: Country

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

Fill gaps in columns: First Name
Group by columns: Last Name, Position

• 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