Excel - How to Create Pivot Table in Google Sheets - Expert Solution

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

Just wondering how I insert a pivot table, i know how to do in excel but can't find a similar function using Google Sheets
Solved by D. F. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/03/2017 - 06:46
Hello there!
Excelchat Expert 14/03/2017 - 06:47
To create a Pivot Table in google sheet, please first select all of your data.
Excelchat Expert 14/03/2017 - 06:48
Then go to Data on the top menu.
Excelchat Expert 14/03/2017 - 06:48
Then please select Pivot Table.
Excelchat Expert 14/03/2017 - 06:49
After that there will be led to a new page on your Google Sheet with your Pivot Table.
Excelchat Expert 14/03/2017 - 06:50
Are you following the steeps?
Excelchat Expert 14/03/2017 - 06:51
Hello there ?
Excelchat Expert 14/03/2017 - 06:53
Are you there?
Excelchat Expert 14/03/2017 - 06:56
Hello?
Excelchat Expert 14/03/2017 - 07:00
If you need more informations please tell us in case to help you.
User 14/03/2017 - 07:01
hi
User 14/03/2017 - 07:01
rry
User 14/03/2017 - 07:01
sorry
User 14/03/2017 - 07:02
i figured out where Pivot Table was
User 14/03/2017 - 07:02
but how do you reorder a column?
User 14/03/2017 - 07:02
I want to manually reorder
User 14/03/2017 - 07:02
i used to just drag and drop in accell
Excelchat Expert 14/03/2017 - 07:05
Okay
Excelchat Expert 14/03/2017 - 07:06
You have to select sort menu and you should have an option to select by your column name then Custom Sort
Excelchat Expert 14/03/2017 - 07:09
Are you there?
User 14/03/2017 - 07:10
yep
User 14/03/2017 - 07:11
where is Sort Menu?
Excelchat Expert 14/03/2017 - 07:13
If you don;t have that option you should have column in the right were you will add columns as fields.
Excelchat Expert 14/03/2017 - 07:14
There you can drag and short your columns.
Excelchat Expert 14/03/2017 - 07:15
The time is running for us, thanks for choosing ExcelChat!
Excelchat Expert 14/03/2017 - 07:15
If you need aga
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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc