+ Reply to Thread
Results 1 to 2 of 2

How do you consolidate data rows?

  1. 04-25-2014, 07:02 AM #1
    mjeffs
    mjeffs is offline
    Registered User
    Join Date
    04-20-2012
    Location
    Thame, Oxfordshire
    MS-Off Ver
    Excel 2007
    Posts
    3

    How do you consolidate data rows?

    Hi All
    I hope I explain myself ok;

    I have attached a simple example of what I am trying to achieve.
    I would like to know how to get Excel to consolidate the rows of data so I am left with a total quantity of new computers and a total quantity of old computers.

    I hope you can help with this.
    Thank you in advance for any advice given.

    Best Regards!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-25-2014, 07:07 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do you consolidate data rows?

    maybe with an pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consolidate multiple worksheets each with 3 header rows and variable number of data rows
    By JacquiC in forum Excel General
    Replies: 1
    Last Post: 11-11-2013, 04:27 PM
  2. how to consolidate data rows..
    By mjeffs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2013, 11:10 AM
  3. [SOLVED] Consolidate Rows in Data Table
    By Janc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 04:39 PM
  4. [SOLVED] Help! Need to consolidate rows and manipulate unique data into columns at rows' end
    By phoenix22 in forum Excel General
    Replies: 2
    Last Post: 05-08-2012, 07:17 PM
  5. [SOLVED] Consolidate data into single rows
    By trent_mac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2012, 03:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1