How to fill rows in the reverse direction?

[Seffana_]

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

[Thableaus · Accepted solution]

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,