Condition according to a code that changes

Hello,

I need your help.
I want to create a condition on my file. The goal is to recover only the beginning and the end of a block of data.

For example :

code | start | end | client
01m 2:03 4:10 Jackson
01m 2:10 4:02 Carla
01m 1:10 3:02 Clara
01m 1:23 3:40 Ed
02i 2:02 2:10 Layla

I want him to send me back: (because the code has changed)

code | start | end | client
01m 2:03 4:10 Jackson
01m 1:23 3:40 Ed
02i 2:02 2:10 Layla

If you have any tips to help me, I'd love to hear from you.

For now, a solution without using code.
1. in column E (from cell E2), insert a formula and drag it down to the end of the data (EN version):

Please Login or Register  to view this content.

or FR version

Please Login or Register  to view this content.

2. filter column E by selecting only "<<<"
3. select any cell in the data range, such as A1, and use the shortcut Ctrl+a
4. copy the selected range and paste it into the desired place
5. delete column E and the last column in the pasted range
6. done

Artik