+ Reply to Thread
Results 1 to 3 of 3

Rearrange Rows into Columns

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    17

    Rearrange Rows into Columns

    I have a report that lists the # of times an agent in a call center passed or failed their call based on specific guidelines. The report that's generated will not show the failed category if they didn't fail any calls. I've attached what the report looks like. I'm trying to format the report so that in column A I have the name, column B the passed calls and column C the failed calls. Column B and C can be interchanged...doesn't matter too much. If they don't have any failed or passed calls, I'd like a 0 to show up. I've tried messing with filters and INDEX/MATCH functions but can't make any headway. Anyone have any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Rearrange Rows into Columns

    In the attached format if there are no Pass or Fail quantity will there still be a line for them?

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Rearrange Rows into Columns

    No there will be not. I'm guessing that makes it more difficult.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 02-27-2014, 03:54 AM
  2. Rows of Users to rearrange in Columns
    By dgdamay in forum Excel General
    Replies: 3
    Last Post: 09-18-2012, 07:28 AM
  3. Rearrange columns using VBA
    By ktpack in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2006, 03:57 PM
  4. Rearrange info in rows to columns - HELP!
    By LaVerne in forum Excel General
    Replies: 0
    Last Post: 06-20-2005, 04:40 PM
  5. Rearrange info in rows to columns - HELP!
    By LaVerne in forum Excel General
    Replies: 0
    Last Post: 06-20-2005, 04:39 PM

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