Okay, if your data is in columns A and B starting in row 2, select cell C2 and go to "Define Name" (On "Formulas" tab of ribbon), NAME: ThisData
Refers to: =Sheet1!B2:INDEX(Sheet1!$B2:$B11, MATCH(TRUE, ISNUMBER(Sheet1!$A3:$A11),0))
Enter
Then copy this VBA into your spreadsheet (ALT + F11 to open VBA Editor)
Close the VBA Editor
That's a function by TigerAvatar that concatenates all within a specific range (which will be "ThisData"
In C2 copied down
=IF(A2,CONCATALL(ThisData,","),""&CHAR(10))
See attachment
Oh, almost forgot, at end of data in A11, I entered a 0 so formula had a stopping point. Note my range in the defined name included the 0.
Bookmarks