- Sub t()
- Dim arr, re(1 To 10000, 1 To 3), i&, j%
- arr = Sheets("原数据").Range("A1").CurrentRegion.Value
- For i = 1 To UBound(arr)
- For j = 1 To Len(arr(i, 3)) Step 2
- cnt = cnt + 1
- re(cnt, 1) = arr(i, 1)
- re(cnt, 2) = arr(i, 2)
- re(cnt, 3) = Mid(arr(i, 3), j, 1)
- Next
- Next
- Sheets("转置").Range("A1").Resize(cnt, 3) = re
- End Sub
复制代码 |