Urgent Salary Pivot Table

I have raw employee information that lists each person’s base salary and their bonuses. I need an Excel workbook—ready within the next two hours—that cleans this data and presents it through a clear, well-formatted pivot table.

The pivot table should let me see total and average pay, quickly filter or slice between base salary and bonus figures, and refresh smoothly when I paste in updated rows later. Feel free to add simple slicers or conditional formatting if that speeds interpretation, but keep the file lightweight and easy for a non-technical user to maintain.

Deliverable (time-critical)
• One .xlsx file containing:
 – the original data moved to a tidy, tabular sheet
 – a separate sheet with the pivot table summarising base salary and bonuses

I’ll be online to send you the source sheet and answer questions as soon as we start, so we can hit the two-hour turnaround.