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