Results 1 to 9 of 9

Combining Columns in Pivot

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2017
    Location
    East Tawas, Michigan
    MS-Off Ver
    Office 2013
    Posts
    25

    Combining Columns in Pivot

    Hello. I am looking to identify if there is a way to combine columns within a pivot. In the attached you will see a sheet called "operator Avg Efficiency By Job" It is of course referencing data from the "master data sheet". Within a manufacturing plant we are looking to track operator efficiency by job using the operator clock number. Some jobs only require 1 operator others can require up to 4. Problem is the same operator depending on the day and the job can be in any spot within columns T-W on the master data sheet depending on how many people run the cell. I would like to figure out a way that it can grab all of the operators no matter what column they are typed into and get it to consolidate into one column in the pivot with the OEE related back to the job they were working. Let me know if this makes sense....i could probably clarify this more.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combining Two Pivot Table Columns into one Sum
    By Agorshkova in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-02-2019, 02:48 PM
  2. [SOLVED] Combining columns in pivot table results.
    By Mr. H2 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-04-2017, 11:37 AM
  3. Combining value count from multiple columns in pivot table
    By AFsimRA in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-05-2013, 11:29 AM
  4. Combining several columns to one in a huge pivot
    By KarinFromSweden in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-11-2012, 08:52 AM
  5. Replies: 2
    Last Post: 08-16-2010, 06:40 PM
  6. Replies: 7
    Last Post: 04-16-2008, 11:25 AM
  7. [SOLVED] Pivot Table combining multiple columns
    By Pete Petersen in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1