Not null column to shift left in mysql

Not null column to shift left in mysql

I am working on MySQL database. I have a table empreporting, this table
contains employeeid and reportingemployeeid columns
SELECT e3.`ReportingEmployeeId` AS Level0,e2.`ReportingEmployeeId` AS
Level1,e1.`ReportingEmployeeId` AS Level2,e1.`EmployeeId` AS Level3
FROM empreporting e1
LEFT JOIN empreporting e2 ON e1.`ReportingEmployeeId` = e2.`EmployeeId`
LEFT JOIN empreporting e3 ON e2.`ReportingEmployeeId` = e3.`EmployeeId`
the above query giving below result:
Level0 Level1 Level2 Level3
\N \N 379 369
\N 379 484 372
\N \N \N 379
Required result format is :
Level0 Level1 Level2 Level3
379 369 \N \N
379 484 372 \N
379 \N \N \N
Pls any one help me. Thanks in advance
Prakash