{{ transformations:FillRightAction.png}}
====== 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<sup>*</sup>|Enter the row to fill the blank cells in.|
|Ignore columns|Select the column(s) where values with //not// be filled across in.|
<sup>*</sup> 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) ^Column(5) ^
|Canada  |   |   |Spain  |   | 
|Quebec  |Montreal  |Ontario  |Barcelona  |Madrid  |

===After (result table)===
^Column ^Column(2) ^Column(3) ^Column(4) ^Column(5) ^
|Canada  |**Canada**  |**Canada**  |Spain  |**Spain**  | 
|Quebec  |Montreal  |Ontario  |Barcelona  |Madrid  |

===Action parameters===
> Row number: 1
> Ignore columns: None selected


\\ 
=====See also=====
  * [[transformations:fillgaps|Fill down]]