Forum Discussion
Need help with organizing a payroll spreadsheet
Hi, I have this painful spreadsheet I am trying to better organize.
It looks like this ...
Name Paycode amount
....
John Doe Regular $10,000
John Doe Overtime $1,000
John Doe Bonus $500
...
But .. I need to reorganize the various earning descriptions into distinct columns so a single person is contained in a single row. Any suggestions?
2 Replies
Hi Matthew,
The most efficient way is to use the https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-A9A84538-BFE9-40A9-A8E9-F99134456576 feature as follows:
Please find the attached file.
I hope this helps you
Haytham
Thank you! I thought pivot tables was the right solution but was having trouble with the Mac version. I'll try it again with my PC.
Best,
Matt
