|
- Sub Macro1()
- Dim arr, brr, i&, j%, p$$, s%, k%
- arr = Range("a2").CurrentRegion
- ReDim brr(1 To UBound(arr) - 1, 1 To 7)
- For i = 2 To UBound(arr)
- brr(i - 1, 1) = arr(i, 1)
- p = "": s = 0: l = 2
- For j = 2 To UBound(arr, 2)
- If arr(i, j) <> "" Then s = s + 1
- p = p & arr(i, j) & ","
- If InStr(p, ",,,,") Or j = UBound(arr, 2) Then
- x = Split(p, ",")
- For k = j - UBound(x) + 1 To j
- If arr(i, k) <> "" Then n = k - 1: Exit For
- Next
- brr(i - 1, l) = n
- brr(i - 1, l + 1) = s
- l = l + 2
- s = 0: p = ""
- End If
- Next
- Next
- Range("t2").Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 |
|