Multirow Formula: How do I fill down referring another column?

[HW1]

I want to fill down a new column with repeated values till the anchor column changes and then the same is repeated.

So I used the multi-row tool to fill down however I am not getting the formula quite right

e.g. 

Customer Number	Name	Site Name	Address	City	State
1,011.00	JRT Alexandria  - N2	JRT Alexandria	2E/46-62 Maddox Street	Alexandria	N2
1,011.00	John R Turk Alexandria	John R Turk Alexandria	2E/46-62 Maddox Street	Alexandria	NSW5
1,011.002	JRT Artarmon  - N2	JRT Artarmon	77 Reserve Road	Artarmon	N2
1011.002	John R Turk Artarmon	John R Turk Artarmon	77 Reserve Road	Artarmon	NSW2

Expected to repeat Name column till Customer Number changes:

Customer Number	Name	Site Name	Address	City	State	New Field
1011.00	JRT Alexandria  - N2	JRT Alexandria	2E/46-62 Maddox Street	Alexandria	N2	JRT Alexandria  - N2
1011.00	John R Turk Alexandria	John R Turk Alexandria	2E/46-62 Maddox Street	Alexandria	NSW5	JRT Alexandria  - N2
1011.002	JRT Artarmon  - N2	JRT Artarmon	77 Reserve Road	Artarmon	N2	JRT Artarmon  - N2
1011.002	John R Turk Artarmon	John R Turk Artarmon	77 Reserve Road	Artarmon	NSW2	JRT Artarmon  - N2

I used this formula:

IF [Customer Number] = [Row+1:Customer Number]
THEN [Row+1:Name] = [Name]
ELSE [Name]
ENDIF

However I am getting:

Customer Number	Name	Site Name	Address	City	State	New Field
1011.001	JRT Alexandria  - N2	JRT Alexandria	2E/46-62 Maddox Street	Alexandria	N2	0
1011.001	John R Turk Alexandria	John R Turk Alexandria	2E/46-62 Maddox Street	Alexandria	NSW5	John R Turk Alexandria
1011.002	JRT Artarmon  - N2	JRT Artarmon	77 Reserve Road	Artarmon	N2	0
1011.002	John R Turk Artarmon	John R Turk Artarmon	77 Reserve Road	Artarmon	NSW2	John R Turk Artarmon

Please find attached example workflow

Help with the correct formula would be greatly appreciated.

Thanks

[sparksun · Accepted solution]

change the formula to:

IF [Customer Number] = [Row-1:Customer Number]
THEN [Row-1:Name]
ELSE [Name]
ENDIF

Then you will get what you want: