Single Row to Multiple Row Determination

[Jim]

I have an excel spreadsheet feed that, for any row A may cover multiple rows
of B. How do I determine programmatically the range of B rows that are
included "within" row A1? (I will be merging all the text contained in the B
rows into one cell for each value of A.) The data is arranged similar to the
following;

A1 B1
B2
B3
B4
A2 B5
B6
A3 B7

 

[Shiva]

Hello,

You have to check the next row of A1 cell having value or not? If that cell
does not contains any value then A1 having more number of values of B.
Whenever you will get new value (not null) in A1 row then new row will start.