how to delete specific rows

[Sshasnk]

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

[PhilipMannering]

Hi @Sshasnk 

It sounds like you just want to keep the numbers? See a possible solution below.

[PhilipMannering · Accepted solution]

If that's not what you want, this does specifically what you ask: "Remove values between Rebate and Reference".

Thanks

Philip

[Sshasnk]

@PhilipMannering  Objective should be to delete rows, I just gave numbers in reference for example but it could be anything

[PhilipMannering]

@Sshasnk Ah, I see. Check my most recent post above and let me know if it does what you need!

[atcodedog05]

Hi @Sshasnk 

Here is a workflow based on logic given by you

Output:

Workflow:

As you can see in the above highlighted its creating a block.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[PhilippK]

Hi @Sshasnk ,

please find my solution attached, which dynamically deletes rows between "Rebate" & "Reference" and changes the header:

Have a great day

Phil 

[PhilipMannering]

@atcodedog05 I'm guessing @Sshasnk also wants to get rid of "Reference" on row 1?

[atcodedog05]

Hi @Sshasnk 

If you have Reference misspelled as Refernce. 

The blocking wont work.

@PhilipMannering 

This expected output as Reference  as first row. As per his logic too.