To generate row based on the cell value

Question

Hi Team,

I have two columns in my input namely ColA & ColB. In ColB in one of the cell I have value as "Indication". So whenever I ma getting this word indication in the ColB I want a new row to be inserted above this "Indication" cell.

Please help me on this

InputColAColB1Section2Terms3Conditions4Queries5Indication

OutputColAColB1Section2Terms3Conditions4Queries  5Indication

philipmannering · Answer

Yeah, it works surprisingly well.

BS_THE_ANALYST · Answer

@PhilipMannering nice. I've never used an IF statement inside the generate rows tool. That's really cool.

philipmannering · Answer

Hey @Gsiva3

Something like this,

Insert Row.yxmd