Martin James

Martin James

  • NA
  • 100
  • 13.9k

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)