Generating row based on specific cell characters

[Gsiva3]

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.

[Gsiva3]

Hi @atcodedog05 

S got it. Thanks for the update:)

[atcodedog05]

Kudos to you 🙂 @Gsiva3 

Happy to help 🙂 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Gsiva3]

Hi @atcodedog05 

In the Multi row formula, the expression in configuration panel is not available. Can you please send me that expression

[atcodedog05]

Hi @Gsiva3

Formula

iif([RowCount]=2,Null(),[_CurrentField_])

Make sure you get the below yellow highlighted config correctly