+ Reply to Thread
Results 1 to 2 of 2

Roll up rows

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Roll up rows

    I have a spreadsheet with multiple rows with data, each has a common cell (say ID#). I wish to roll up each row to make it one row within the ID#. No column will overlay anything from another row.


    ID# A B C
    111 xxx xxx
    111 xxx

    I want it to look like this:

    ID# A B c

    111 xxx xxx xxx

    Can I do this with basic EXCEL?
    Attached Files Attached Files
    Last edited by Kevin 33; 02-05-2017 at 06:53 PM. Reason: add example

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365

    Re: Roll up rows

    This sounds like something you can accomplish with a pivot table - you should be able to show it in tabular form without the row headers repeating.

    To tell more, we'd have to see a sample file.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Creating a spreadsheet with roll up/dn rows
    By jksjim in forum Excel General
    Replies: 1
    Last Post: 09-02-2016, 01:27 PM
  2. roll up/consolidate rows with addition
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2015, 07:06 PM
  3. [SOLVED] 2 rows of sheets instead of roll left and right
    By marko737 in forum Excel General
    Replies: 3
    Last Post: 09-13-2013, 08:26 PM
  4. Roll multiple rows of text into one row
    By davidx in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2013, 06:27 AM
  5. Need Odd # to Roll to Even #
    By tnoble17 in forum Excel General
    Replies: 8
    Last Post: 01-30-2010, 02:09 PM
  6. Roll Off
    By George4 in forum Excel General
    Replies: 3
    Last Post: 09-25-2008, 12:31 AM
  7. Help with Macro: summing together/roll over rows (Energy Trading, see example)
    By dstock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 03:39 PM


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