fill "up" the value

Jes_Li

Hi,

A quick question, is there a way to fill "up" the value like I have below data:

	a	20
	b	30
	c	40
Cash	Total	90
	d	200
	e	0
Non-cash	Total	200

And I want to fill the empty becoming this:

Cash	a	20
Cash	b	30
Cash	c	40
Cash	Total	90
Non-cash	d	200
Non-cash	e	0
Non-cash	Total	200

Thanks.

Jes_Li

Found the answers here. Thanks.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multi-Row-Formula-to-quot-copy-up-quot-values/td-p/86395