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 |
@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 nice. I've never used an IF statement inside the generate rows tool. That's really cool.
Yeah, it works surprisingly well.