+ Reply to Thread
Results 1 to 3 of 3

Merging Rows with multiple selections

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Merging Rows with multiple selections

    I have a data array of 7 col and 256 rows. I want to focus only on the first 2 columns though. Here is what is going on. In the first column I have numbers from 1-256, these numbers are merged to the appropriate size to accommodate the data in column 2. However, the data in column 2 is not merged, it consists of 1,2, or 3 lines of text. Excel deletes the text in the rows below 1 if I try to merge, excel does not allow multiple row merge selections. What I am looking for is a formula that looks at column 1, finds how many rows are being merged in column 1, then looks at column 2 and identifies the number of rows needed for merging and displays that text in only one row. Basically, it's a formula that merges multiple rows of text in col 2 depending on the number of merged rows in col 1.

    No. Customer/Operator

    1 Fairbanks Morse /
    Beloit, WI
    2 H+H Umwelttechnik /
    UBS AG Zürich
    3 Didier/Blohm + Voss
    Steinwerder
    4 Siemens KWU KPW
    Redwitz
    5 Hanseatische Aktiengesellschaft
    ARGE Tangermünde
    6 Calpine Energy /
    Phila., PA
    7 Patten Power /
    Elmhurst, IL
    5 Lebo Türen Werke

    6 Blohm + Voss/
    Hoogovens

    7 Integral/
    Dieselmotoren Rostock
    8 Polyma/
    Stadtwerke Pfarrkirchen
    9 Monhoff-Handels GmbH
    Kunststoffrecycling Himberg
    10 Staatliches Bauamt
    Köln II Bundesamt für Verfassungsschutz

  2. #2
    Forum Contributor
    Join Date
    09-16-2009
    Location
    Dallas, TX
    MS-Off Ver
    Office 2013
    Posts
    107

    Re: Merging Rows with multiple selections

    A couple things:

    1) Formulas can't merge anything--you'll need a VBA function for that.
    2) You might be able to figure out how many rows are merged; are the merged rows unique? Do they ever repeat the same value?
    3) Posting a sample sheet would help a great deal.

    Dan

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Merging Rows with multiple selections

    No not all the merging rows are unique. Some are already merged, some need to merge 2 rows, and some need to merge 3 rows. All can be based on the merged rows in column 1.

    I have attached a sample sheet.
    sample merging file.xlsx
    Last edited by carlc711; 07-03-2013 at 11:09 AM.

+ 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