I don't know if I understood you correctly.
In my solution, all cells in the B: G range must be unmerged.
I used helper column 'J' for sorting.
Sorting for "Symbol".
Sub Sort_Symbol()
Dim lr As Integer
With Application
.EnableEvents = False
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With
With Sheets("Journal")
lr = .Cells(Rows.Count, "B").End(xlUp).Row + 5
.Range("J6:J" & lr).Formula = "=INDEX(B:B,AGGREGATE(15,6,ROW($B$1:$B$600)/" _
& "($B$1:$B$600=""Symbol""),COUNTIF($B$5:B6,""Symbol""))+1)"
With Sheets("Journal").Range("B6:J" & lr)
.Sort Key1:=.Cells(1, 9), order1:=xlAscending, _
Header:=xlGuess
End With
.Columns("J").ClearContents
End With
With Application
.EnableEvents = True
.Calculation = xlCalculationAutomatic
End With
End Sub
Sorting for "Entry Date".
Sub Sort_Entry_Date()
Dim lr As Integer
With Application
.EnableEvents = False
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With
With Sheets("Journal")
lr = .Cells(Rows.Count, "B").End(xlUp).Row + 5
.Range("J6:J" & lr).Formula = "=INDEX(C:C,AGGREGATE(15,6,ROW($B$1:$B$600)/" _
& "($B$1:$B$600=""Symbol""),COUNTIF($B$5:B6,""Symbol""))+1)"
With Sheets("Journal").Range("B6:J" & lr)
.Sort Key1:=.Cells(1, 9), order1:=xlAscending, _
Header:=xlGuess
End With
.Columns("J").ClearContents
End With
With Application
.EnableEvents = True
.Calculation = xlCalculationAutomatic
End With
End Sub
Bookmarks