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
Bookmarks