Results 1 to 2 of 2

Merge 2 columns into 1

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2013
    Posts
    6

    Merge 2 columns into 1

    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
    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] Merge duplicate rows and merge the columns (approx 10 columns)
    By adfeddon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2012, 11:19 AM
  2. [SOLVED] Merge columns if certain number of columns in row
    By FreeThrow in forum Excel General
    Replies: 9
    Last Post: 06-22-2012, 03:04 PM
  3. Merge 2 Columns
    By Julian Potter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2012, 03:41 AM
  4. merge text from 2 columns into 1 then delete the old 2 columns
    By sleepindogg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-30-2006, 02:30 PM
  5. [SOLVED] Need to merge columns
    By Jay T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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