Martin James

Martin James

  • 2k
  • 96
  • 3.1k

Group Employee by 2 departments

Mar 19 2021 12:03 PM
I have the following table :
EmpID DeptID PayrollID
Aa        130       211
Aa        110       211
And I would like to change it to :
ID DeptID1 DeptID2 PayrollID
Aa 130        110          211

Answers (1)