neededing to make text pivot table if possible

  • Thread starter Thread starter jewels
  • Start date Start date
J

jewels

I need to look at my employees names & the job they did on each
particular day. Maybe something similar to the pivot table could help.
Something that I could pull one persons name and every date & the job
they did I could easily see. Or I could pull the job title and I could
see the data that way. Is there a way to put this information into the
spreadsheet in a certain way where some formula can help me??
 
Jewels,
If you show how your data is set out it may help to advise you.
If you're staring from scratch, I'd make sure that you have the top row
(immediately above the data) show Column headers such as...
Employee Name Job Title Date Etc....
Enter data immediately below those headings.
Then setting up a pivot table should be relatively easy once that's done.
Also if you set it out this way you can also use AutoFilter which is a
useful tool to filter data.
Rob
 
Thanks Rob for the tip - Here is an example
Date Employee Name Job Title
March 3 John Painting
March 3 Jane Painting
March 3 Doug Insulation
March 4 Jessica sheetrock

Now there is a very small example. So how do I pull this information by
date. Like if I want to see everyone who worked on March 3 and what
they did. Or how do pull the information by one employee - If my
example showed the whole month I would have the same employees maybe 10
times a month sometimes with the same job sometimes not. The only thing
I have ever seen that can do that kind of thing is pivot tables - but
pivot tables need numbers and this is all text.
 
I like Rob's second suggestion--Data|Filter|autofilter.

Select your range of data (include only the bottom most header row) and
data|filter|autofilter.

Use the dropdown arrow for each field to show the stuff you want.

There's an option for Custom, too. There's lots of stuff you can do:

Contains, begins with, ends with, Does not equal, and more.

And if you filter by more than one column, you'll be reducing the data--the
filters are cummulative.
 
Jewels:

I too would go for AutoFilter. And it gets even more powerful if yo
give a little thought beforehand to the key words you might use in th
data fields (columns).

A totally unconnected example: a teacher kept notes on pupils and th
words bully, bullying and bullied were in the field. A custom enquir
for ' contains "bull"' found them all.

Al
 
Back
Top