Tranpose data Problem

[excelhelp18]

Hi, I need help on transposing the data in the desired format.

I have attached the sample file for your help. There is a set of data for a defined period for certain geography.

In the attached file, there is a CI visit tab which have data on the site visited by CI in a geography. Cell J3 has site visited on a particular day , each site seperated with comma.

What I require is the transpose of these sites along with the Zone, CI name, Cluster and date on which site was visited. sample view of required data is given in the tab "result".

Looking forward to your response on this. Thanks in advance.

Regards