fill in the blank record with the last record

[anselyuan]

here i have encountered a problem that i cannot fill in the blank space with the last record. anyone can help? I uploaded an excel doc with 2 sheets. One is question, one is the result I want.

[Joe_Mako · Accepted solution]

How about the attached?

[Bob_Blackey]

@Joe_Mako

The rumors are true - once you become an Alteryx Ace you never need sleep. Cool. :-)