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...
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