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

then what can i help you with?

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

add it plz.

Excelchat Expert
09/08/2017 - 05:36

first add names then add the emplyee number

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

PLEASE REPLY.

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