no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+{{ transformations:FillRightAction.png}}
+====== FILL RIGHT ======
+Category: Transform / Advanced\\
+\\
+=====Description=====
+This action is similar to the [[transformations:fillgaps|Fill down]] action, only it fills empty cells to the right.\\
+\\
+=====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 blank cells to the right 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:**  Fill in the blank heading cells from an imported Excel pivottable.
+**Source table:**
+^Column ^Column(2) ^Column(3) ^Column(4) ^Column(5) ^Column(6) ^Column(7)^
+|Canada  |   |   |France  |   |Spain  |   |
+|Quebec  |Montreal  |Ontario  |Paris  |Lyon  |Barcelona  |Madrid  |
+\\
+**Action parameters:**
+> Row number is "1"
+> Ignore columns - none are selected
+\\
+**Result table:**
+^Column ^Column(2) ^Column(3) ^Column(4) ^Column(5) ^Column(6) ^Column(7)^
+|Canada  |Canada  |Canada  |France  |France  |Spain  |Spain  |
+|Quebec  |Montreal  |Ontario  |Paris  |Lyon  |Barcelona  |Madrid  |
+\\
+=====See also=====
+  * [[transformations:fillgaps|Fill down]]