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
sure
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
yeah
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
ok
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
ok
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
ok
Excelchat Expert
13/10/2018 - 10:16
Are you using excel for your file?
User
13/10/2018 - 10:17
yes
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
ok
User
13/10/2018 - 10:19
thanks
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.