+ Reply to Thread
Results 1 to 4 of 4

Rearrange data that come in row.

  1. #1
    Registered User
    Join Date
    02-06-2020
    Location
    Shah Alam
    MS-Off Ver
    365 Pro
    Posts
    2

    Rearrange data that come in row.

    Hi,

    I'am Ika. I am currently being assigned to provide time spend for each assignee and need to exclude pending hour. The problem is the the data comes in rows.
    Attachment is the data that i need to work on. I really have no idea on how and where to start. Seeking anyone expert here.
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,776

    Re: Rearrange data that come in row.

    Hi,

    Try using a Pivot Table and exclude Pending using the filter..

    See the file attached
    Attached Files Attached Files
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  3. #3
    Registered User
    Join Date
    02-06-2020
    Location
    Shah Alam
    MS-Off Ver
    365 Pro
    Posts
    2

    Re: Rearrange data that come in row.

    Hey Dave,

    Tq for your response.
    See, under each name, there might be "Pending" duration. The "Pending" duration might not be there, might only one or might have many.
    I actually want to exclude those pending hour. The data is actually showing the whole life cycle of all ticket.
    For example, if you sort the Mi_Value = Mubeen Taj, you can see the he had move a same ticket number to "Pending" status.
    Basically, i want to count sum of duration and exclude the pending hours.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,124

    Re: Rearrange data that come in row.

    It may help if you manually provide a small sample of what you are attempting to accomplish so that we can try to automate the process using formulas, features and/or code.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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