Advanced Sum Macro

hello honorable excel profesionals.
here is what i want the macro to do:

must start from the top of the colum and count cells with specific data in them:

if ''X'' or ''Xa'' or ''Xb'' -> start counting how many cells in a row have the value specified.
from here two things can happen:

if a cel with a value ''Y'' is met -> stop
if a cell with value '''Ya'' or '''Yb'' is met -> countinue counting untill Y is met

when I say stop I mean that the macro should imput, ona separete table:
1.total number of how many counts where made.
2.how many counts there where with a lenght of 1, how many with the lenght of 2 and so on

here is an example of data line and a table I want to have after macro is done.

Hope that this isn,t a problem to write otherwise il have to do this manualy - about 5000 rows of data...