Can anyone tell me How to combine two rows into one.

Mar 26 2013 6:43 AM
Hi,
Can anyone tell me How to combine two rows into one.
 
EMPCode	    actHours	        actDate		rowno
107	    8.00		2013-01-21 	1
107	    8.30		2013-01-22 	1
107	    4.00		2013-01-23 	1
107	    4.00		2013-01-23 	2
107	    4.10		2013-01-24 	1
107	    4.20		2013-01-24 	2
107	    4.30		2013-01-25 	1
107	    4.30		2013-01-25 	2
 
I want the result as follows:
 
actHours	   actDate	
8.00		   2013-01-21 
8.30		   2013-01-22
8.00		   2013-01-23 
8.30		   2013-01-24
9.00		   2013-01-25 	
 
Any help will be appreciated. Thanks in advance Smile | :)

Answers (1)