Search for Cell and Copy row below

[manfredkarl]

Hi everyone and thank you right away for your help. 

Currently I am facing the following problem: 

I want to find a specific cell (here B-Area in Column 3) and cut the entire column 5 (starting in the row where i found the String "B-Area") and paste it in Column 7. 

It is pretty difficult to explain therefore attached two screenshots: 
Thats how it looks rn: 
 

Thats how it currently looks: 

And that is the format I need to move on: 

I would really appreciate your help. 

Best regards

manfredkarl

[BenMoss]

Hi!

If you could attach the sample data that would be great!

Ben

[manfredkarl]

Hi Ben, 

of course. I'm sorry. 

Thanks for your help. 

[danrh · Accepted solution]

I'd use something along these lines:

The Multi-Row Formula tool checks to see which row 'B-Area' starts on, then flags that row and all rows below it.  The Formula tool then copies the contents for every row that is flagged and empties out the cells where the data was prior.  The Select tool at the end is just to drop the flag column I created with the Multi-Row.

Good luck, hope it helps!

[manfredkarl]

Thank you very much. Worked perfectly this way.