Hey guys,
I'm trying to pull info from a number of cells into one cell, the only thing is that the number of cells I'm referencing change, for example, one cell might pull info from 3 cells below, and another might pull info from the 8 cells below. Basically, I'm trying to pull info from all the children items into a parent item. It should pull all the info from the children until it hits a blank cell - that blank cell is the new parent.
I have attached a screenshot of the sample data. In the first one, you can see that D2 should pull all the info from D3 - D5, D6 should pull info from D7 - D9, and D10 should pull all the info from D11-D16
Any help is appreciated!
Thanks
excel2.JPG
Bookmarks