Using a Macro in Excel to Sort Data in 2 columns and align the rows with like data

I need to align data in 4 columns.
2 of the columns have the same data but they are not in the same row.

C1 and C3 have the same data.
C2 and C4 have numerical data that varies.
I need to align C1 and C2 with C3 and C4.

Problem:
C1 C2 C3 C4
A # A #'
B # B #'
C # C #'
D #
E #
F #
E #'
F #'

Desired:
C1 C2 C3 C4
A # A #'
B # B #'
C # C #'
D #
E # E #'
F # F #'
...
...

If the attached is not what you wanted, need to see your file.