Query to Convert Rows to Columns with Unique Data in SQL Server

Hi

 In below data i want to get Unique Values from EMP fields. I n below data i want 4 records. E01,E02,E03,E04 Since E02 is duplicate

using Sql Query

   Customer      Emp_1     Emp_2     Emp_3     Emp_4

      C001               E01         E02

      C002                E03        E04          E02

Thanks