Thread: Sort merged cells

Why did yuo merge cells? You could rich the same result by enlarging column width.Can't you now unmerge them?

I suggest you to unmerge em all, then delete unnecesary columns. and set width, say 25 pt.?!

well you can start by unmerging cells then alignment horizontal center across selection instead to give the same appearence

Try this and see if

......the big guys out there..

notice!

Code:

Sub TidyPasta()
    Cells.MergeCells = False
    r = Cells(1, 1).End(xlDown).Row
    c = Cells(r, Columns.Count).End(xlToLeft).Column + 6
    For i = c To 3 Step -1
        If Cells(Rows.Count, i).End(xlUp).Row = 1 Then
            Columns(i).Delete
        End If
    Next
    r = Cells(Rows.Count, 1).End(xlUp).Row
    For i = r To 2 Step -1
        Range("F" & i & ":G" & i).MergeCells = True
        Range("A" & i & ":B" & i).MergeCells = True
    Next    
    Columns("A:G").ColumnWidth = 12.75
End Sub

P.S.

Before running

Delete the instructions and result you need to obtain shown in your sample workbook.

Cheers

well, i got some different result in my test here.. please see bellow the result from the code and the result expected.

result from code resullt expected
10 00235 01 ==== 10 00231 01
10 00235 05 ==== 10 00231 08
10 00235 06 ==== 10 00231 10
10 00380 07 ==== 10 00231 11
10 00380 08 ==== 10 00231 12
10 00380 09 ==== 10 00231 18
10 00231 10 ==== 10 00235 01
10 00231 11 ==== 10 00235 05
10 00231 12 ==== 10 00235 06
10 00231 18 ==== 10 00380 07
10 00231 08 ==== 10 00380 08
10 00231 01 ==== 10 00380 09




the Columns A and B (as second condition) were not well sorted..

Avoid Merged Cells like the plague

The source is probably not native Excel but comes from a reporting system like Chrystal Reports or Business Objects. Notorious for putting gazillions of columns in between fields and merging across. Looking at the number of columns involved in the display of five values, I bet that's what it is.

@jwnyc,

I don't see any connection of your comment to the question. Please take heed when posting comments. Have a look at the forum rules before posting anything else.