Dragging down a value

[caldowd1998]

Hi community,

Any ideas on how i would transform the first image into something like the second one with the values dragged down ? I've tried multi row formula but this just does one at a time.

thanks !

[Sebastiaandb]

@caldowd1998  Are you sure?

[atcodedog05 · Accepted solution]

Hi @caldowd1998 

Here is how you can do it. You can do it using multi-row formula tool.

Workflow:

Resource : https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872 

Hope this helps : )