Hi there,
I have a simple (think its simple) issue with a pivot table
I have 4 rows.
1. Date
2. Supervisor
3. Worker
4. Time
I want a statistic about each individual time per day. Sometimes supervisor "Z" can be worker next day so he is listed in the other row.
I need to merge row B and C somehow.
Cheers, Jean
Hi, and welcome to the forum
I think you probably meant you have four columns.
I think you need these four
Date
Staff Category (values will be either Supervisor or Worker)
Name
Time
When you have the data in that format you'll be able to use a Pivot Table more efficiently.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks