TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to fill down values for multiple groups of data


Let's say that we have data in the following format:

The first three rows are of category "Electronic", and the two rows after that are of category "Rap". We want to populate the category of music for every row.

To do this, we use a formula step with the following logic: if the category column is not blank, we want the row to have this value. If the category column is blank, we want to reference the cell above.

This equates to this formula:

=IF(ISBLANK(A1), D0, A1)

Note the reference to cell D0, which is a relative reference to the cell above.

This means when the formula is evaluated in e.g. row 4, it takes the value from row 3.

We end up with data in this format: