Concatenate rows and count them

[dank4000]

Hey,
I know this should be simple but I can't even contemplate how to do it.
Basically I'm importing some data from an HTML table into excel, it all formats pretty well except that some of the data appears on multiple rows.

What I have...

A B C
1 01.02.06 John
2 Bob
3 Sam
4 02.03.06 Jim


What I need:

a b c
1 01.02.06 John, Bob, Sam 3
2 02.03.06 Jim 1

What I think I want to be trying to do is IF row$ in Column A is blank then CONCATENATE row$ to row$-1, delete row. repeat until end of spreadsheet

and in column C count row$ column b, repeat till end of sheet


Not a clue of the type of syntax I should be using though!
In fact there's probably a better way of importing the data from the HTML so it doesn't even need to be done this way! of course I'm oblivious to it.

[dank4000]

Thinking maybe I didn't make myself properly clear....

If a cell in column a is empty then it means the item in column b needs adding to the end of the item in the row above in column b.

I then want to count the items in column b.

Any ideas?

Thanks

[dank4000]

I don't know why I didn't do this in the first place! Please see attached screenshot. Hopefully the rest of my confused mess will make a bit more sense now.
Any ideas? Thanks
screenshot.JPG