Sub 数据分离()
Dim rng As Range, t As Integer, irow As Long
t = 4
For Each rng In Range("A1").Resize(Range("A" & Rows.Count).End(3).Row, 1)
If rng = "NAME" Then t = t + 2
irow = Cells(Rows.Count, t).End(3).Row + 1
If Cells(1, t) = "" Then irow = 1
Cells(irow, t) = rng
Cells(irow, t + 1) = rng.Offset(, 1)
Next
End Sub
代码我没测试,你自己试一下吧。