Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need help with pivot tables, I can provide an example
Solved by A. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/10/2018 - 10:12
Welcome to Excelchat, I see that your question is about Pivot tables.
Excelchat Expert 13/10/2018 - 10:12
I can help you with that problem, I'll be able to give you a solution and an explanation. Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 13/10/2018 - 10:12
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 13/10/2018 - 10:12
May you please share the data you have so I can help you with your concern? You can also paste a sample data on the document preview pane.
User 13/10/2018 - 10:12
User 13/10/2018 - 10:13
ok done
Excelchat Expert 13/10/2018 - 10:14
Based on what you've shared, you need help in creating a pivot table from what your data looks like to a specific view shown on the preview pane. Do you believe that will address your problem?
User 13/10/2018 - 10:15
Excelchat Expert 13/10/2018 - 10:15
Ok I'm going to create the pivot table needed to get the output you want. This should take me less than 20 minutes. If we need more than 20 minutes, you'll be able to extend the session up to 60 total minutes.
User 13/10/2018 - 10:15
Excelchat Expert 13/10/2018 - 10:15
I'll be working in the shared spreadsheet. When our session is over you'll be able to access the solution in your session history by downloading the Excel File.
User 13/10/2018 - 10:15
User 13/10/2018 - 10:15
i just got an issue that said unable to load file
User 13/10/2018 - 10:15
is that fine?
User 13/10/2018 - 10:16
ok i'm back in the file
Excelchat Expert 13/10/2018 - 10:16
I see, maybe the file is just loading.
Excelchat Expert 13/10/2018 - 10:16
I’m working on your solution. But don’t worry, I’ll be updating you throughout!
User 13/10/2018 - 10:16
Excelchat Expert 13/10/2018 - 10:16
Are you using excel for your file?
User 13/10/2018 - 10:17
Excelchat Expert 13/10/2018 - 10:19
Ok I'll work on this in excel instead since google sheet pivot table is a bit different and I can't do the output you need. I will send you the excel file once I'm done
User 13/10/2018 - 10:19
User 13/10/2018 - 10:19
Excelchat Expert 13/10/2018 - 10:23
Here's the file with the pivot table
[Uploaded an Excel file]
Excelchat Expert 13/10/2018 - 10:23
Does this solution solve your problem?
User 13/10/2018 - 10:23
yes but I have a ton ofe events
User 13/10/2018 - 10:24
i don't want to drag them all into the values column one by one
User 13/10/2018 - 10:24
how can I speed that up?
Excelchat Expert 13/10/2018 - 10:27
Oh I see, but that's the limitation we have for the pivot table with the kind of data you have. Maybe you will need to have the workaround on your original data first to change how it currently looks like so it would be easier to attain the final output you need.
Excelchat Expert 13/10/2018 - 10:28
If you can share your data, we may be able to think of a solution on how we will do that
User 13/10/2018 - 10:28
hmm ok
User 13/10/2018 - 10:29
i guess time is running short so I will just drag all of them down
Excelchat Expert 13/10/2018 - 10:29
You can click them one by one on the pivot fields instead of dragging them one by one
User 13/10/2018 - 10:30
oh ok
Excelchat Expert 13/10/2018 - 10:30
then once everyone is checked, then you can drag the values to rows
Excelchat Expert 13/10/2018 - 10:30
To show it under the name
Excelchat Expert 13/10/2018 - 10:30
Do you have any other questions about this problem and the solution?
User 13/10/2018 - 10:31
nope, thank you very much
Excelchat Expert 13/10/2018 - 10:31
Thanks for coming to Excelchat. Please feel free to leave any comments or give your kind feedback for our service. Have a nice day! :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc