Convert Row data into column against one id

Dec 16 2018 5:06 AM

I have data in Rows like

DateTime Status EmpId

2018-05-28 8:00 01 2000347

2018-05-28 20:18 02 2000347

2018-05-28 8:00 01 2000348

2018-05-28 17:18 02 2000348

Now i want above data convert into columns like this

EmpID Status (1)INTime Status(2)OutTime

2000347 2018-05-28 8:00 2018-05-28 20:18

2000348 2018-05-28 8:00 2018-05-28 17:18

means same date data will come against one ID

Kindly help ..

Answers (6)