if previous column data in merged cell, count merged rows, combine data in next column corresponding rows in to 1 row

[leecavturbo]

a1-a3 are merged, data in unmerged b1-b3 correspond to data in a1-a3. combine data from b1-b3 to b1. then unmerge a1-a3
then delete empty rows
then repeat down.

EG
(11-sep vis is in merged a1-a3. pretty pigs is in b1,tamworth in b2 and b in b3) so cut tamworth and b and paste on the end of pretty pigs. now unmerge a1-a3 and then delete empty row 2 and 3. then repeat down until no data in column a


11-Sep VIS PRETTY PIGS
TAMWORTH
B
11-Sep BP ADAMS
BOARD

FIXED UNMERGED

11-Sep VIS PRETTY PIGS TAMWORTH B
11-Sep BP ADAMS BOARD

 

[Fluff]

Hiya
Give this a go on a copy of your data

Sub UnMergeMe()

    Dim CurCl As Range
    Dim NxtCl As Range
    Dim Rws As Integer
    Dim I As Integer

    Set CurCl = Range("A1")
    Do
        Set NxtCl = CurCl.Offset(1)
        Rws = NxtCl.Row - CurCl.Row - 1
        CurCl.UnMerge
        For I = Rws To 1 Step -1
            CurCl.Offset(I - 1, 1) = CurCl.Offset(I - 1, 1) & " " & CurCl.Offset(I, 1)
            CurCl.Offset(I).EntireRow.Delete
        Next I
        Set CurCl = CurCl.Offset(1)
    Loop While CurCl.Value <> ""


End Sub