**Question description:**

*This user has given permission to use the problem statement for this
blog.*

i need someone to get me through the basics of pivot tables

Solved by M. A. in 52 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
06/04/2018 - 06:55

Hello! Welcome to Excel chat.

User
06/04/2018 - 06:55

hello Ref

Excelchat Expert
06/04/2018 - 06:56

I understand that you want to learn some basics about Pivot tables.

User
06/04/2018 - 06:56

kindly help with my problem thanks

Excelchat Expert
06/04/2018 - 06:56

Sure.

Excelchat Expert
06/04/2018 - 06:56

Please share your data.

User
06/04/2018 - 06:57

i dont have any data, like i said i would like to go through the major basics of pinot tables

User
06/04/2018 - 06:57

pivot tables sorry i swhat i meant

Excelchat Expert
06/04/2018 - 06:57

Ok.

Excelchat Expert
06/04/2018 - 06:58

You want to know how to create a Pivot table?

Excelchat Expert
06/04/2018 - 06:58

May I know which Excel version you are using.

User
06/04/2018 - 06:58

of whta importance it is, how to creat e it and how to use it. am using excel 2016

Excelchat Expert
06/04/2018 - 06:59

Ok. Got it.

User
06/04/2018 - 07:00

Hello you are still there??

Excelchat Expert
06/04/2018 - 07:00

The importance of Pivot table : In simple terms, it summarizes your data in terms of sum, count, average etc.. Allows you to filter your data on various parameters.

Excelchat Expert
06/04/2018 - 07:00

Yes. I am here only.

Excelchat Expert
06/04/2018 - 07:01

Let me add some sample data to the sheet and then we will discuss a problem which can be solved by a pivot.

User
06/04/2018 - 07:01

waiting

Excelchat Expert
06/04/2018 - 07:02

Thanks. Just give me few minutes.

Excelchat Expert
06/04/2018 - 07:06

There is some data in the sheet now. Please have a look at that.

Excelchat Expert
06/04/2018 - 07:09

So, let's talk about a Pivot here.

Excelchat Expert
06/04/2018 - 07:09

Suppose you want to count Republican and Democrat voters and see it in a summary table.

User
06/04/2018 - 07:10

ok lets go

Excelchat Expert
06/04/2018 - 07:12

Sure.

User
06/04/2018 - 07:13

so what now???

User
06/04/2018 - 07:13

is that th epivot table?

Excelchat Expert
06/04/2018 - 07:13

Please see the Pivot Table 1.

User
06/04/2018 - 07:14

how did u comre up to that?

Excelchat Expert
06/04/2018 - 07:17

Sure, let me explain the process.

User
06/04/2018 - 07:18

yo taking long to reply asap

Excelchat Expert
06/04/2018 - 07:19

I am sorry for that. But some issues at network at my end.

User
06/04/2018 - 07:19

ok

Excelchat Expert
06/04/2018 - 07:21

Open your original spreadsheet and remove any blank rows or columns.
Make sure each column has a heading, as it will be carried over to the Field List.
Make sure your cells are properly formatted for their data type.
Highlight your data range
Click the Insert tab.
Select the PivotTable button from the Tables group.
Select PivotTable from the list.

Excelchat Expert
06/04/2018 - 07:23

That's how the pivot table is created.

Excelchat Expert
06/04/2018 - 07:27

Drag an item such as Last Voted from the PivotTable Field List down to the Row Labels quadrant. The left side of your Excel spreadsheet should show a row for each value. You should also see a check mark appear next to.

**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.*