Excel- Offset

[Martrica]

I would like to add an offset function to the index aggregate when the first blank is identified go look at another column.

Thanks in advance.

[#2]

@Martrica 

Perhaps small sample file? What is "index aggregate", where blanks are identified, etc.