Merging Rows

  • Hello, first post hope you all can help.
    I'm trying to write a macro that can merge rows if Column A is blank.
    i.e.
    test |1
    test |2
    test |3
    test2 |4
    test2 |5



    So Test would be row 1 test2 would be row 2. As opposed to test2 being being row 4.


    I used JoinRows macro found at mvps.org/dmcritchie/excel/join.htm But am having trouble modify it to see if there are blanks in column A.


    Any help or ideas would be greatly appreciated.


    Thanks

  • answer


    Ok, I'm not sure if i completely understand your question, but the following chunk of code will eliminate any blank cells by moving data to the first available row.
    -----------------------

  • Assuming not deleting rows where Col A is blank


  • merging rows


    Hello.
    Thank you for the quick replies.
    I want to merge the rows vertically, but not delete them.
    Col 1 : Col 2 : Col 3
    Row 1: test 34 valid
    Row 2: test 34 ic audit
    Row 3: more 23 3e



    desired result
    col 1 : col2: col3
    Row 1: test 34 valid
    test test test 34 ic audit
    Row 2: more 23 3e



    I hope the above is clear.
    Farron

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!