copying and pasting

[masterid]

I have a data like below

[TABLE="width: 540"]
<tbody>[TR]
[TD]Dealer name
[/TD]
[TD] Location
[/TD]
[TD] 12-06-2013
[/TD]
[TD] 13-06-2013
[/TD]
[TD] 14-06-2013
[/TD]
[/TR]
[TR]
[TD]J.k Agencies
[/TD]
[TD] Ambur
[/TD]
[TD]
[/TD]
[TD] No issues
[/TD]
[TD] No issues
[/TD]
[/TR]
[TR]
[TD]Sri A.J & cext
[/TD]
[TD] Ambur
[/TD]
[TD]
[/TD]
[TD] CC problem
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]MJ agencies
[/TD]
[TD] tambaram
[/TD]
[TD] not visited due to rain
[/TD]
[TD] not done
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]gt store
[/TD]
[TD] chennai
[/TD]
[TD] done
[/TD]
[TD] no problem in ID
[/TD]
[TD] problem on
[/TD]
[/TR]
[TR]
[TD]mm agencies
[/TD]
[TD] coimbatore
[/TD]
[TD] have issues
[/TD]
[TD]
[/TD]
[TD] no problem in ID
[/TD]
[/TR]
[TR]
[TD]SSS enterprises
[/TD]
[TD] kanchi
[/TD]
[TD]
[/TD]
[TD] closed
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

I want the above data to become like this

[TABLE="width: 415"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Dealer
[/TD]
[TD]Location[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]J.k Agencies[/TD]
[TD]Ambur[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]Sri A.J & cext[/TD]
[TD]Ambur[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]MJ agencies[/TD]
[TD]tambaram[/TD]
[TD]not visited due to rain[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]gt store
[/TD]
[TD]chennai[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]mm agencies[/TD]
[TD]coimbatore[/TD]
[TD]have issues[/TD]
[/TR]
[TR]
[TD]12-06-2013[/TD]
[TD]SSS enterprises[/TD]
[TD]kanchi[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]J.k Agencies[/TD]
[TD]Ambur[/TD]
[TD]No issues[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]Sri A.J & cext[/TD]
[TD]Ambur[/TD]
[TD]CC problem[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]MJ agencies[/TD]
[TD]tambaram[/TD]
[TD]not done[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]gt store[/TD]
[TD]chennai[/TD]
[TD]no problem in ID[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]mm agencies[/TD]
[TD]coimbatore[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]13-06-2013[/TD]
[TD]SSS enterprises[/TD]
[TD]kanchi[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]J.k Agencies
[/TD]
[TD]Ambur[/TD]
[TD]No issues[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]Sri A.J & cext[/TD]
[TD]Ambur[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]MJ agencies[/TD]
[TD]tambaram[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]gt store[/TD]
[TD]chennai[/TD]
[TD]problem on[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]mm agencies[/TD]
[TD]coimbatore[/TD]
[TD]no problem in ID[/TD]
[/TR]
[TR]
[TD]14-06-2013[/TD]
[TD]SSS enterprises
[/TD]
[TD]kanchi[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

Sorry i could not draw the grid line. i want it in excel.
Kindly help me.

 

[Special-K99]

I dont see an image

 

[masterid]

I dont see an image

Please see now i have changed it.