Swapping some column headers with values in another column

[LilE]

Hello,
I have a workbook that records Department, Employee Classification, and Project as columns with each project being its own column. The purpose of the sheet is to track salary expenditures of a given department for a given employee class for a given project. Employee classifications can repeat within its column given that multiple departments can have employees belonging to the same class. I want to have it so that the employee classifications each have their own column rather than the projects and the projects take the place of where the employee classifications are now. In the attachment I've provided an example of what the end result should look like in Sheet2. How would I go about making this alteration?

[Sam Capricci]

give this a try in sheet2 cell C2 dragged across then down...
=SUMPRODUCT((Sheet1!$A$2:$A$10=Sheet2!$A2)*(Sheet1!$C$1:$E$1=Sheet2!$B2)*(Sheet1!$B$2:$B$10=Sheet2!C$1),Sheet1!$C$2:$E$10)

[alansidman]

Employing Power Query, I unpivoted your table and loaded it back to Excel where I then created a Pivot Table. All is shown in the attached file. In power query, the Mcode to unpivot your table is shown below.

Please Login or Register  to view this content.

If you are unfamiliar with Power Query, then click on one of the links in my signature block.

[LilE]

That did it! Thank you so much!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.