{{transformations:FillRightAction.png?nolink }}
====== FILL RIGHT ======
Category: Transform / Advanced
=====Description=====
This action fills the empty cells across columns, within rows, by duplicating the value of the last non-empty cell to the left of the empty ones. The cells are filled rightward.
=====Use cases=====
The most frequent use case for this action is dealing with merged cells within imported Excel spreadsheets.
=====Action settings=====
^Setting ^Description ^
|Row number*|Enter the row to fill the blank cells in.|
|Ignore columns|Select the column(s) where values with //not// be filled across in.|
* Setting can be specified using a [[:parameters|parameter]].
=====Remarks=====
Blank cells are populated starting from the left and moving rightward across the row. The value from the cell to the left is used to fill in each blank cell.
=====Examples=====
====Example #1====
>Fill in the blank heading cells from an imported Excel pivottable.
===Before (source table)===
^Column ^Column(2) ^Column(3) ^Column(4) ^
|Canada | |Spain | |
|Quebec |Montreal |Barcelona |Madrid |
===After (result table)===
^Column ^Column(2) ^Column(3) ^Column(4) ^
|Canada |**Canada** |Spain |**Spain** |
|Quebec |Montreal |Barcelona |Madrid |
===Action parameters===
> Row number: 1
> Ignore columns: None selected
=====See also=====
* [[transformations:fillgaps|Fill down]]