I have a requirement to summerize my employee data by Employee id, Department, Job and Project. Would like to know whether this is possible.
I am including sample of Raw data and the expected results. Any help is greatly appreciated.
Raw Data
Expected Result
------------------------------
Dn Pr
------------------------------