Combining Columns with Dynamic Values

[whalay]

Dear Pros,

Please how can I use formula to create COLUMN C from A and B?

 

[Dave87]

i think you need to have a look at that picture again, there doesnt seem to be any obvious link between column C and columns A & B... what are you trying to do?

 

[Eric W]

There actually is a well-defined pattern to the results in column C, but it would be quite complicated for a formula. I took a stab at it, and ran out of time. It's actually far better suited to a VBA macro:

Sub Reorg()
Dim MyData As Variant, cbreak As String, r As Long, i As Long

    MyData = Range("A2:B" & Cells(Rows.Count, "A").End(xlUp).Row).Value
    cbreak = ""
    r = 2
    
    For i = 1 To UBound(MyData)
        If MyData(i, 1) <> cbreak Then
            Cells(r, "C") = MyData(i, 1)
            Cells(r, "C").Font.Bold = True
            cbreak = MyData(i, 1)
            i = i - 1
        Else
            Cells(r, "C") = MyData(i, 2)
        End If
        r = r + 1
    Next i
End Sub

This only took about 5 minutes to write, and it allows bolding the headers which you can't do in a formula.