|
- Sub mystr()
- Dim ar, br, i%, n%, x%, s&, strs$
- ar = Range("a1:c13")
- For i = 1 To 3
- For n = 1 To UBound(ar, 1)
- If ar(n, i) <> "" Then
- strs = strs & ar(n, i) & " "
- End If
- Next n
- Next i
- Range("e:g") = ""
- br = Split(RTrim(strs), " ")
- s = 1
- For x = 1 To 3
- Cells(s, x + 4).Resize(UBound(br) + 1, 1) = Application.Transpose(br)
- s = s + UBound(br) + 1
- Next x
- End Sub
复制代码
|
|