# 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 to pull employee numbers and names and match them on a new worksheet using pivot table?
Solved by S. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/08/2017 - 05:22
Hello Welcome to GotIt Pro.
User 09/08/2017 - 05:22
I dont know if I need to be using a pivot table or lookup for what i need?
Excelchat Expert 09/08/2017 - 05:23
May I have a look at your data?
User 09/08/2017 - 05:27
ok
User 09/08/2017 - 05:27
so i need to turn this data into a pivot table
Excelchat Expert 09/08/2017 - 05:28
yes. now you want to match what with what?
Excelchat Expert 09/08/2017 - 05:28
on basis of?
User 09/08/2017 - 05:28
and i only need employee name, number, premium total, and employer total
User 09/08/2017 - 05:28
i don't know how to
Excelchat Expert 09/08/2017 - 05:28
let me show you how to create a pivot table.
User 09/08/2017 - 05:29
display the employee number on the pivot table
Excelchat Expert 09/08/2017 - 05:29
click on Data -> Pivot Table
User 09/08/2017 - 05:29
without it summing
Excelchat Expert 09/08/2017 - 05:29
okay
User 09/08/2017 - 05:29
in excel
Excelchat Expert 09/08/2017 - 05:30
In excel you have to go to Insert and then click pivot table on left
User 09/08/2017 - 05:30
i already created my pivot table with all my info
Excelchat Expert 09/08/2017 - 05:30
User 09/08/2017 - 05:31
except the employee number, it has to reflect 6 digits
User 09/08/2017 - 05:31
and i need to match it to the corresponding employee on the table
User 09/08/2017 - 05:31
so
User 09/08/2017 - 05:31
if
User 09/08/2017 - 05:31
Boy George in A5..
User 09/08/2017 - 05:32
I want to figure out how to put his employee number in B!
User 09/08/2017 - 05:32
B1*
User 09/08/2017 - 05:32
Boy George in A1 sorry
Excelchat Expert 09/08/2017 - 05:32
yes
Excelchat Expert 09/08/2017 - 05:33
here you go
User 09/08/2017 - 05:33
can you show me how?
User 09/08/2017 - 05:33
will this work if...
User 09/08/2017 - 05:34
I have the name listed multiple times in a row?
Excelchat Expert 09/08/2017 - 05:34
you just have to click on Values from pivot table windw and add emplyee number
Excelchat Expert 09/08/2017 - 05:34
yes it will work at every condition
Excelchat Expert 09/08/2017 - 05:34
even if you add more names and more employee numbers, it will update
Excelchat Expert 09/08/2017 - 05:35
did you get it?
User 09/08/2017 - 05:35
do i add employee number to Values?
Excelchat Expert 09/08/2017 - 05:35
are you there?
Excelchat Expert 09/08/2017 - 05:36
yes exactly
Excelchat Expert 09/08/2017 - 05:36
Excelchat Expert 09/08/2017 - 05:36
User 09/08/2017 - 05:36
it keeps adding the employee number under the name, but i want in to re
Excelchat Expert 09/08/2017 - 05:36
very good
User 09/08/2017 - 05:36
in excel
Excelchat Expert 09/08/2017 - 05:37
you have to uncheck the show total over there.
User 09/08/2017 - 05:37
where?
Excelchat Expert 09/08/2017 - 05:37
like here,, in rows- add field, uncheck show total check box
Excelchat Expert 09/08/2017 - 05:39
can you send screenshot of your excel where you are facing problem
Excelchat Expert 09/08/2017 - 05:39
i have unchecked the box. You can see now its not showing any total
Excelchat Expert 09/08/2017 - 05:40
Kindly come over to this sheet to continue our conversation as session time is about to end: https://docs.google.com/spreadsheets/d/1vOUVAPtfBirnfLPAAuN_uSOigsRDFU5VkGbKKkHxcFk/edit?usp=drive_web
Excelchat Expert 09/08/2017 - 05:40

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.