How to fill rows in the reverse direction?

Question

Hello,

Does anyone know how to fill rows in the reverse direction?

As in get the string value in Record #15 [Award] to fill up the empty rows all the way to #1 and the string value in Record #27 [Award] to fill up the empty rows all the way up to #16 and so on?

I have tried multi-row formula but only know how to use it going in a downwards direction.

Thank you,

Seffana

SAG Awards.yxmd

Thableaus · Accepted Answer

Hi @Seffana_

The secret is to sort your data in a reverse order (using RecordID), and then use Multi-Row Formula Tool to fill-in the empty spaces.

Workflow of this example appended.

Cheers,