Hi everyone,

Can someone help with creating a code to run for this task, (I don't think it is possible without VBA but I am a beginner).

So in range (B2:Bxxxx), run down the range one cell at a time,
Condition 1. If the cell is blank and the adjacent cell in column A is blank then move down to the next cell in column B
Condition 2. If the cell in column B already contains a text move to the next cell down,
Condition 3. If the cell is blank and the adjacent cell in column A contains a value then copy the text in the cell above from column B and move down
The gaps between the products shouldn't be more than 15 rows so if Condition 1 is repeated more than 15 times, STOP.

this is how it looks now

A B

20 Apple
10


40 Banana
60
170
80



30 Orange
60
10