Sub zh()
Dim arr(), s%, i%, r As Range, rn As Range
Set rn = Range("c3").CurrentRegion
s = rn.Count
ReDim arr(1 To s)
For Each r In rn
If r <> "" Then
i = i + 1
arr(i) = r.Value
End If
Next
Range("m3").Resize(s) = Application.Transpose(arr)
End Sub
Sub zzh()
Dim h%, i%, k, arr, brr
h = Cells(Rows.Count, 3).End(xlUp).Row
arr = Range("c3:k" & h)
ReDim brr(1 To UBound(arr, 1) * UBound(arr, 2), 1 To 1)
For i = 1 To UBound(arr, 1)
For h = 1 To UBound(arr, 2)
If arr(i, h) <> "" Then
k = k + 1
brr(k, 1) = arr(i, h)
End If
Next h
Next i
[m3].Resize(UBound(brr), 1) = brr
End Sub
Sub zh()
Dim arr(), s%, i%, r As Range, rn As Range
Set rn = Range("c3").CurrentRegion
s = rn.Count
ReDim arr(1 To s)
For Each r In rn
If r <> "" Then
i = i + 1
arr(i) = r.Value
End If
Next
Range("m3").Resize(s) = Application.Transpose(arr)
End Sub