Concatenate column of data based on interation value in other column

[wheel1]

I have a large sheet of data that I wish to concatenate. One column contains basically an iterative count of rows following the initial entry. I am trying to concatenate all of the rows following, not including the initial entry and restart over again each time the iterative count changes. Blank cells in the iterative column should be ignored.

A simple IF then Concatenate forumula quickly runs out of character limits due to size as some iterate over 40 rows. I've tried several VB solutions on the forum but none seem to fit my specific needs.

Any suggestions?

concat-test.xlsx

[xladept]

Maybe:

Please Login or Register  to view this content.

[FDibbins]

Not exactly what you wanted, but see if you can work with this.

I inserted a blank row atthe top of your data to help.

Put this in C2 and copy down...
=TRIM(IF(A2="",C1&" "&B2,B2))

[Crooza]

Or here's a VB solution

Please Login or Register  to view this content.