Sub CopyTranspose()
Dim Rws As Long, Col As Integer, J As Long, W As Long, Z As Integer
With Sheets("So Lieu")
Rws = .[B1].CurrentRegion.Rows.Count
Col = 1 + .[B1].CurrentRegion.Columns.Count
ReDim Arr(1 To Rws * Col, 1 To 2)
Sheets("Ket Qua").[D1].Resize(Rws * Col, 2).Value = Arr()
For J = 1 To Rws Step 2
For Z = 1 To Col
If .Cells(J, Z).Value <> "" Then
W = W + 1: Arr(W, 1) = .Cells(J, Z).Value
Arr(W, 2) = .Cells(J + 1, Z).Value
Else
W = W + 1: Arr(W, 1) = "END"
GoTo GPE
End If
Next Z
GPE: Next J
End With
If W Then
Sheets("Ket Qua").[D1].Resize(W, 2).Value = Arr()
End If
End Sub