copying and pasting

[masterid]

I have a data like below

Dealer name	Location	12-06-2013	13-06-2013	14-06-2013
J.k Agencies	Ambur		No issues	No issues
Sri A.J & cext	Ambur		CC problem
MJ agencies	tambaram	not visited due to rain	not done
gt store	chennai	done	no problem in ID	problem on
mm agencies	coimbatore	have issues		no problem in ID
SSS enterprises	kanchi		closed

<tbody>
</tbody>

I want the above data to become like this

Date	Dealer	Location	Remarks
12-06-2013	J.k Agencies	Ambur	0
12-06-2013	Sri A.J & cext	Ambur	0
12-06-2013	MJ agencies	tambaram	not visited due to rain
12-06-2013	gt store	chennai	Done
12-06-2013	mm agencies	coimbatore	have issues
12-06-2013	SSS enterprises	kanchi	0
13-06-2013	J.k Agencies	Ambur	No issues
13-06-2013	Sri A.J & cext	Ambur	CC problem
13-06-2013	MJ agencies	tambaram	not done
13-06-2013	gt store	chennai	no problem in ID
13-06-2013	mm agencies	coimbatore	0
13-06-2013	SSS enterprises	kanchi	Closed
14-06-2013	J.k Agencies	Ambur	No issues
14-06-2013	Sri A.J & cext	Ambur	0
14-06-2013	MJ agencies	tambaram	0
14-06-2013	gt store	chennai	problem on
14-06-2013	mm agencies	coimbatore	no problem in ID
14-06-2013	SSS enterprises	kanchi	0

<tbody>
</tbody>

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.