Duplicate Rows Value

[Mostafa_Anwar]

Hi All,

I want to create duplicate rows for specific values, Below is the current dataset

I want to achieve the below:

Attached is the dataset.

Thanks in advance.

Regards,

[danilang · Accepted solution]

Hi @Mostafa_Anwar 

You can do this with a Multi-row tool configured like this

if isnull([F1]) then
	[Row-1:F1]
else
	[F1]
endif

giving you 

Dan

[Mostafa_Anwar]

Many thanks Dan!