+ Reply to Thread
Results 1 to 4 of 4

Consolidating and converting table data - Help!

  1. #1
    Registered User
    Join Date
    10-31-2011
    Location
    Tyne and Wear
    MS-Off Ver
    Excel 2007
    Posts
    5

    Consolidating and converting table data - Help!

    I have a table with 5 columns:

    Date - LoginID - Exception - Start - Stop

    I have attached an example of the data.

    What I am trying to achieve is to convert this table into a usable format for another system to do this I need to do several things.

    First I need roll up all the instances of "Open Time" in the "Exception" field so that per day, per ID there is only 1 entry remaining which shows the minimum value found in "Start" and the maximum value found in "Stop" as the other system only logs "Open Time" as 1 entry as opposed to a breakdown of each segment in the table I have provided.

    I also need to split the breaks in the table into 2 separate Breaks using minimum value from "Start" and minimum value from "Stop" to get first break and the same again but with maximum values to get the second break.

    I am running a complete blank and have tried various methods to no avail.

    I would be forever grateful if someone could take some time to either solve this problem or point me in the right direction as I have not been able to find what I need by searching the forum.

    Many thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    346

    Re: Consolidating and converting table data - Help!

    you have forgotten to attach an example of data

  3. #3
    Registered User
    Join Date
    10-31-2011
    Location
    Tyne and Wear
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Consolidating and converting table data - Help!

    I can't seem to find an option to add a file from the menu? I will recreate the table in a post in a few minutes. Thanks for letting me know

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Consolidating and converting table data - Help!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. Consolidating many tables from one sheet to a master table including all the data
    By Michell Feitosa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2014, 09:29 AM
  2. Consolidating data with a chart or pivot table
    By ehitt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-24-2013, 11:08 PM
  3. [SOLVED] Converting data in a table into a list
    By Speshul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 03:13 PM
  4. Consolidating data for pivot table
    By floricita in forum Excel General
    Replies: 0
    Last Post: 09-01-2010, 09:03 AM
  5. Consolidating data in one Pivot Table.
    By Kianuz in forum Excel General
    Replies: 2
    Last Post: 10-23-2009, 10:24 AM

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