+ Reply to Thread
Results 1 to 5 of 5

Merge multiple columns and rows as individual rows....

  1. #1
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Merge multiple columns and rows as individual rows....

    If I have a table like the one on the left. Notice how the rows include ones where there is no information.

    The results should look like the right. The contents should be joined, and cells merged (and aligned to the left) for all the columns selected. It should then go to the next selected row and do the same and continue until either the end of the selection or there is no data in all 3 cells.

    I have code to do this with a single row of multiple selected columns, but I don't know how to expand this to multiple selected rows.

    Please Login or Register  to view this content.
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,860

    Re: Merge multiple columns and rows as individual rows....

    use the concatenate function. https://www.techonthenet.com/excel/f...oncatenate.php

  3. #3
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    427

    Re: Merge multiple columns and rows as individual rows....

    Hi
    If you insist on code
    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,464

    Re: Merge multiple columns and rows as individual rows....

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Re: Merge multiple columns and rows as individual rows....

    alan - concatenate, isn't that a function and not VBA? Also, that doesn't merge cells or handle selections.
    mohadin - got an error "We can't do that with a merged cell"?
    jindon - Perfect! Does exactly what I needed - no more, no less!

+ 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. How to merge excel columns into multiple rows
    By OMID313 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2018, 12:18 PM
  2. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  3. [SOLVED] Merge multiple (and variable) rows and columns by repeating value
    By moreron in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2013, 02:19 AM
  4. [SOLVED] Merge multiple duplicate rows into columns - more than 65536 rows
    By a3des in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2013, 09:18 AM
  5. [SOLVED] How to Merge multiple duplicate rows into columns
    By geiollex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-04-2013, 03:03 PM
  6. Merge rows according to unique IDs in column A- with multiple columns
    By inbars in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-26-2013, 08:03 PM
  7. Replies: 1
    Last Post: 11-29-2012, 06:24 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1