Duplicate Rows Value

Question

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,

Book1.xlsx

danilang · Accepted Answer

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