convert data into a list in excel 2

The file is composed of 3 parts: 1/ column A to G: do not alter or modify 2/ Column H to BW: for every line, do the following: a) when you see a cell with the word situation, group the following cells together until b) when you a cell with the word activités, group the following cells together until c) when you see a cell with the word services, group the following cells together until d) when you see a cell with the word info pratique, group the following cells together 3/ column BX to end For every time you see the words (check caps) MOBILHOME, TENTE, CAMPING, YOURTE, BUNGALOW, bungalow toilé, Studio, APPARTEMENT, STUDIO, VILLA, then group the following cells together until you find the same word again, meaning it is a new product. Lines have to remain unchanged, as we need all info in the same line with the ids