hi, i need some help!
based on the image attached:
I need to concatenate from APPLE to the last column in its row and down all the rows and columns UNTIL It sees APPLE again.
My problem is that I am being able to concatenate but only the first row correctly and some others. (The number of rows under apple are not always the same as you can see , the first, for instance is 2, 4, 3)
So the results would in a cell in the line of apple or last blank line before next apple.
RESULTS ARE IN YELLOW in the image.
your help would be greatly appreciated