Removing rows and recalculating depths in Excel 2010

[Eligeol]

Hi All,
I have a challenge which I hope someone can help me with. I have a bunch of data from holes drilled into the earth and I need to remove certain layers and recalculate or “bump up” the layers below. E.g.:
0 2.7 No Core
2.7 4.07 Dolerite Fine
4.07 6.96 Sandstone Fine
6.96 7.9 Sandstone Medium
7.9 13.38 Dolerite Fine
13.38 15.68 Sandstone Fine
15.68 15.76 Conglomerate
15.76 18.9 Sandstone Medium
18.9 24.42 Sandstone Fine
24.42 25.57 Sandstone Medium
25.57 27.4 Siltstone
27.4 28.43 Dolerite Fine
28.43 30 Siltstone
30 46.26 Shale (Light)
46.26 50 Dolerite Fine
50 57.78 Dolerite Medium
57.78 60.88 Dolerite Fine
60.88 65.28 Shale (Dark)

I need to remove all the layers called "Dolerite" (Fine, Medium & Coarse etc.) and move each of the other layers up by whatever the thickness of the Dolerite layer is to get this:
0 2.7 No Core
2.7 5.59 Sandstone Fine
5.59 6.53 Sandstone Medium
6.53 8.83 Sandstone Fine
8.83 8.91 Conglomerate
8.91 12.05 Sandstone Medium
12.05 17.57 Sandstone Fine
17.57 18.72 Sandstone Medium
18.72 20.55 Siltstone
20.55 22.12 Siltstone
22.12 38.38 Shale (Light)
38.38 42.78 Shale (Dark)

Is there some sort of formula that I can use or way of doing this besides the very tedious manual way I have been using so far? There are about 300 of these to do!
Please help!?

[Pepe Le Mokko]

Deleting all rows containing given text is easy using a filter, but I have no idea how you get the new strings before the description

[Eligeol]

Yeah - thats my problem - its not just a simple delete - the other layers depths have to be recalculated...

[Pepe Le Mokko]

And how is that achieved?