Hello

In column A I have non consecutive cells, in column B I want them to be consecutive.
I can't use VBA for this project , is there a way with array formula to do so ?


Thanks

A B
1 Banana Banana
2 Strawberry
3 Strawberry Strawberry
4 Strawberry Orange
5 Orange Orange
6 Orange
7
8 Orange
9
10 Orange