Hi Community and Happy new Year!
I'm looking at the Multi-Row Formula, but I can't wrap my head around on how to do this.
I have data like this below
| ID | Identifier | Amount |
| 15687 | Line | 10 |
| 15687 | Line Split | 5 |
| 15687 | Line Split | 5 |
| 15688 | Line | 20 |
| 15699 | Line | 24 |
| 15699 | Line Split | 12 |
| 15699 | Line Split | 12 |
| 15700 | Line | 56 |
It is group by the ID, the desire is to delete the first row "Line"' if the second row and after is Line Split in the Identifier.
How can I achieve this with Multi-Row Formula? or is there a different tool better use?
Thank you!
