Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Consolidate Data (Excel 2000/2003)

    Hi

    I have to consolidate data, Sample Attached, Consolidate Data will only bring the numbers across it there a way to also bring over the text column?

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Consolidate Data (Excel 2000/2003)

    Please explain exactly what you mean by consolidate.
    (In a workbook with only one populated sheet, there is nothing to consolidate)

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Consolidate Data (Excel 2000/2003)

    Hi Hans

    This is only a small sample of the data
    Row 2 and Row row 7 have the are the same code but different quantities,

    If if use Data/Consolidate I get columsn A C and D consolidated but the description column is misssing because Data/Consolidate from the Data Menu does not consolidate text.

    Hope this is clearer.


    Please see attached

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Consolidate Data (Excel 2000/2003)

    That is not consolidation.

    Use Data | Filter | Advanced Filter with the "Copy to another location" and "Unique records only" options to create a list of unique SKUs and Descriptions, then use SUMIF formulas to sum Qty and Value.

    Or - probably easier - create a pivot table based on the data and hide the subtotals. See attached version.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Consolidate Data (Excel 2000/2003)

    Hi Hans

    Sorry about the terminology Consolidate, that's what is say's in the menu, so that's why if reffered to it as Consolidate.

    Having said that obviously the way to go is with the pivot table as you suggest.

    Thanks for the guidance

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Consolidate Data (Excel 2000/2003)

    Consolidate is on the menu, but it means adding data from different ranges together. You want to aggregate data from a single range.

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Consolidate Data (Excel 2000/2003)

    Hi Hans

    Thanks for the explanation.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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