To generate row based on the cell value

[Gsiva3]

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 

Input
ColA	ColB
1	Section
2	Terms
3	Conditions
4	Queries
5	Indication

Output
ColA	ColB
1	Section
2	Terms
3	Conditions
4	Queries
5	Indication

[Christina_H]

Something like this?

[BS_THE_ANALYST]

@Gsiva3 one way:

Using the multi-row to identify the Indicator row. This allowed me to create a flag on that row, and all the rows below it. 
Then filtering indicator row and below from the top section. Then adding a dummy row in. Then unioning everything together

[PhilipMannering]

Hey @Gsiva3 

Something like this,

[BS_THE_ANALYST]

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

[PhilipMannering]

Yeah, it works surprisingly well.