Sub chuyenduleu()
Dim arr, arr1, ten As String, lr As Long, a As Long, i As Long, j As Long
With Sheets("R_data")
lr = .Range("A" & Rows.Count).End(xlUp).Row - 2
If lr < 9 Then Exit Sub
arr = .Range("A9:g" & lr).Value
ReDim arr1(1 To UBound(arr, 1), 1 To 7)
For i = 1 To UBound(arr, 1)
If Len(arr(i, 3)) = 0 Then
If arr(i, 1) = "Khách hàng:" Then
ten = arr(i, 2)
End If
Else
If arr(i, 2) = Empty Then arr(i, 2) = arr(i - 1, 2)
a = a + 1
arr1(a, 1) = ten
arr1(a, 2) = arr(i, 2)
arr1(a, 3) = arr(i, 3)
arr1(a, 4) = arr(i, 4)
arr1(a, 5) = arr(i, 5)
arr1(a, 6) = arr(i, 6)
arr1(a, 7) = arr(i, 7)
End If
Next i
End With
With Sheets("data")
lr = .Range("B" & Rows.Count).End(xlUp).Row
If lr > 4 Then .Range("B4:h" & lr).ClearContents
.Range("B4").Resize(a, 7).Value = arr1
End With
End Sub