I have data in rows but want to retrieve in columns with multiple values.

NewEmpID    OldCode Att_Time    AttDate     Attend_Status
1540        20939   8:58    1-Apr-2024  IN
1540        20939   13:19   1-Apr-2024  OUT
1540        20939   18:14   1-Apr-2024  OUT
1540        20939   9:46    2-Apr-2024  IN
1540        20939   13:12   2-Apr-2024  OUT
1540        20939   16:44   2-Apr-2024  OUT
1540        20939   9:28    3-Apr-2024  IN
1540        20939   13:09   3-Apr-2024  OUT
1540        20939   16:04   3-Apr-2024  OUT
1540        20939   8:57    4-Apr-2024  IN
1540        20939   16:04   4-Apr-2024  OUT
1540        20939   8:59    5-Apr-2024  IN
1540        20939   16:05   5-Apr-2024  OUT
1540        20939   8:54    6-Apr-2024  IN
1540        20939   16:04   6-Apr-2024  OUT
1540        20939   8:59    9-Apr-2024  IN
1540        20939   13:14   9-Apr-2024  OUT
1540        20939   16:06   9-Apr-2024  OUT

want to retrieve in following format

ID  OldCode 01_IN   01_OUT  02_IN   02_OUT  03_IN   03_OUT  04_IN   04_OUT  05_IN   05_OUT  06_IN   06_OUT  07_IN   07_OUT  08_IN   08_OUT  09_IN   09_OUT  10_IN   10_OUT
1540    20939   8:58    13:19   9:46    13:12   9:28    13:09   8:57    16:04   8:59    16:05   8:54    16:04                   8:59    13:14       
            18:14       16:44       16:04                                               16:06