I have data in column now i want to separat it status wise one col Status(1)IN and Col(2)Out
| EmpID | DateTime | StatusINOUT |
| 1 | 2018-05-26 08:44 | 1 |
| 1 | 2018-05-26 08:44 | 2 |
| 2 | 2018-05-28 08:44 | 1 |
| 2 | 2018-05-28 12:44 | 2 |
| 1 | 2018-05-21 08:44 | 1 |
| 1 | 2018-05-21 10:44 | 2 |
| 2 | 2018-05-23 08:44 | 1 |
| 2 | 2018-05-23 08:44 | 2 |
Now i want to display Status wise INTIME(1) and OUTTIME(2) it as below
| Empid | INTIME(1) | OUTIME(2) |
| 1 | 2018-05-26 08:44 | 2018-05-26 08:44 |
| 2 | 2018-05-28 08:44 | 2018-05-28 12:44 |
| 1 | 2018-05-21 08:44 | 2018-05-21 10:44 |
| 2 | 2018-05-23 08:44 | 2018-05-23 08:44 |