Copy a specific row to another based on a value in the column

Question

Hi Everyone,

I wanted to copy the whole row into a new row if the column B contains a specific value.

In the attached sheet, if the Column B has the value ATF XYZ, I would like that whole row to be copied again.

Thanks,

Rudraksh

Expected.xlsx

Actual.xlsx

flying008 · Accepted Answer

Hi, @RudrakshPandey

FYI.

RowCount <= IIF(Contains([Name], 'ATF XYZ'), 2, 1)