Generating row based on specific cell characters

Hi all,

I have a input as attached below. I have four columns named as A,B,C & Length of B.

So now what I want is, if the value in Length of B column is = 17, I need two separate outputs as mentioned below

(a)then I need to generate a new row

(b) Then I need to generate a duplicate row with data from the row that contains Length of B=17

Can anyone please suggest me a way to do this so.

Datasets

Accepted answers

Dont use quotes use 3 not "3"

You can copying the below formula and using it. I have changed the column name.

IF [Length of MFAL]="21" THEN 3 ELSE 1 ENDIF

Here is a workflow for the task.

You can set row count as 2 for length of B = 17 or else 1 and generate rows accordingly.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Thanks for the reply.

My one more requirement is I need to add empty row based on the above mentioned

Can you help me with it