Hello!
I have a spreadsheet that looks something like this:
Capture.JPG
I've been trying to come up with a formula that I could paste down column B that will give me this:
Capture2.JPG
There's obviously many ways to do this when you've got 3 groups and 3-5 rows per group but I've got 200 groups (non-empty cells in column A) and they can have anywhere from 2 to 100 values in column C.
I've tried to come up with a TEXTJOIN like TEXTJOIN(",",TRUE,C2:INDIRECT("C"&(2+COUNTBLANK(B2:B###)),TRUE).
I think my problem is that I can't figure out how to count the number of empty cells between two non-empty cells without identifying which cells aren't empty by hand.
Thanks for any help you can provide.
Bookmarks