Automatic transposition depending on occurence & Incidence of value per month

Apologies "shg"

Dear All,

This is my first post, please be gentle with me!

I have a worksheet which is extracted from another piece of software (Interherd) & I have some data....

What I'd like to do is paste the data into a worksheet, then have the data copied (automatically) onto the next worksheet, but in the order I would like it, specifically:
One of the datasets comes as comma delimited values (in the same cell)
e.g. BL,BR
I would like the BL to appear in a new row (into a newly created row so that the data below isn't disrupted) & also the associated info to be transferred
e.g. the date associated with the BL

I would then like to know how many times BL appears per month
The date values are entered as 28/3/08, therefore between the 1/3/08-31/3/08 how many times does BL appear?

I hope this makes sense, I've attached a pdf to demonstrate the data (couldn't get the Excel file attached)

Thanks for any help in advance

Jim