MULTI ROW FORMULA

[dunkindonut7777]

Hi I want to learn how to copy down the values using the multi row formula tool. My data is having a column with empty cells below and I want to fill it in using the value preceding the empty cell.

Sample:

Code	Expected Output
1	1
	1
	1
	1
2	2
	2
	2
	2
3	3
	3
	3
	3

Can you help me with this one please

[Qiu]

@dunkindonut7777 
You can refer this similar question

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multi-Row-Formula-auto-fill-bl...

[dunkindonut7777]

Hello @Qiu 

Can you help me how to fill this up like the expected output column:

Raw Data:                                                                   Expected Output:

CODE	ID #
1	88100
	78800
	95201
	66904
	41800
	85500
	45100
	45100
	89700
	71400
	71409
	89700
	41800
	5800
	82000
	38500
	67000
	83300
	83300
	83302
	41800
	84303
	85500
	67000
	67100
	67102
	67103
	67104
	67106
	67104
	67105
	84100

Expected output: 

CODE	ID #
1	88100
1	78800
1	95201
2	66904
2	41800
2	85500
3	45100
3	45100
3	89700
3	71400
3	71409
4	89700
4	41800
5	5800
5	82000
6	38500
6	67000
6	83300
6	83300
6	83302
7	41800
7	84303
8	85500
8	67000
8	67100
8	67102
8	67103
8	67104
8	67106
8	67104
8	67105
8	84100

I'm having a hard time designating unique number for each entries.

[Qiu]

@dunkindonut7777 
We can use the Multi-row formula tool to check if the last row of "ID #" is null then add 1 to last row of "CODE" then use Formula tool to process further.

[binuacs]

@dunkindonut7777 one way of doing this