+ Reply to Thread
Results 1 to 5 of 5

Merge similar cells based on the left column

  1. #1
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2021
    Posts
    211

    Merge similar cells based on the left column

    Hi everyone,

    I need help with this request please.

    I have a big data set. Sample of it looks like this. Sample file is also attached.

    So column A contains merged cells. Is there anyway column B, C and D can be merged based on the merged cells in column A
    For example,
    A2, A3, and A4 are merged and therefore, only B2, B3 and B4 are merged. Same thing with C and D
    A5, A6, and A7 are merged and therefore, only B5, B5 and B7 are merged. Same thing with C and D
    merge cells.jpg

    I really appreciate your help
    Attached Files Attached Files

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

    Re: Merge similar cells based on the left column

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2021
    Posts
    211

    Re: Merge similar cells based on the left column

    Thanks so much jindon. The code is awesome. The only thing it doesnt merge similar cells in Column D.

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

    Re: Merge similar cells based on the left column

    Ahhh
    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2021
    Posts
    211

    Re: Merge similar cells based on the left column

    Quote Originally Posted by jindon View Post
    Ahhh
    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.
    Thank you so much. It worked perfect. You saved a lot of time for me.

    I really appreciate it.

    Regards,

    M

+ 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. Replies: 6
    Last Post: 06-26-2017, 09:04 PM
  2. [SOLVED] Merge similar cells in column and adjacent columns
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2016, 06:58 AM
  3. Macros merge cells in a column based on same cell in another column
    By NADIAYO in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2015, 04:29 PM
  4. [SOLVED] Merge similar data in a nother column
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2014, 06:11 PM
  5. [SOLVED] Merge cells in corresponding column based on similar values
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 12-22-2014, 10:54 AM
  6. Merge Selected cells and shift column contents Left
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2014, 02:22 PM
  7. need to merge cells in column B based on data in column A
    By saintdesy in forum Excel General
    Replies: 2
    Last Post: 08-15-2012, 05:50 AM

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