I have multiple rows where I have to delete rows which is above a row called a reference, below is an example.
| Field1 |
| Reference |
| 1 |
| 2Nov |
| Rebate |
| welcome |
| Refernce |
| 56 |
| 89 |
| Rebate |
| Fee table 12 |
| Rebate |
| penalties |
| Reference |
| 1RTV |
| 2DFB |
| 4 |
What I am trying to do:
1. I have to delete all the rows which come between Rebate and Reference
2. The number of rows in between rebate and reference could be any number
3. change the column name from field1 to Reference
My final output:
| Reference |
| 1 |
| 2Nov |
| 56 |
| 89 |
| 1RTV |
| 2DFB |
| 4 |
The solution should be deleting the rows as reference number/Hexa/Letter could anything (Probably using row formula)
Let me know if you have any doubt
