Help with Pivot Table.
Budget: ₹100 – ₹400 INR
I have two spreadsheets that I need merged and a summary table built from. Should be relatively quick and straight forward.
Attached is total tickets group by company name.
It shows individual tickets by company, and the priority of each ticket. (high medium or low).
Also attached is a list of company names along with the Partner Name and CSM Name. Each spreadsheet has some other columns that we don't care about.
I'd like a summary spreadsheet that shows:
Company Name; CSM Name; Partner Name; Total # of high tickets, Total # of medium tickets; Total # of low tickets..
Can you help? The company names SHOULD be a complete match. But there might be a few manual checks to do just in case.
Attached is total tickets group by company name.
It shows individual tickets by company, and the priority of each ticket. (high medium or low).
Also attached is a list of company names along with the Partner Name and CSM Name. Each spreadsheet has some other columns that we don't care about.
I'd like a summary spreadsheet that shows:
Company Name; CSM Name; Partner Name; Total # of high tickets, Total # of medium tickets; Total # of low tickets..
Can you help? The company names SHOULD be a complete match. But there might be a few manual checks to do just in case.