Select Column and Identify First and Last non blank cell value per segment (Range between Blanks)

[snb]

I prefer import.

[J.Suarez]

Hello snb, as for the import! I'm not aware of an import being able to concatenate or provide the same as what Mr. Rothstein has created. I'm interested in seeing how this would be accomplished through an import method. Please elaborate.