|
本帖最后由 xhczq 于 2013-11-8 10:49 编辑
附件有详细说明,谢谢!
本帖最后由 xdragon 于 2013-11-8 11:45 编辑
- Sub t()
- Dim arr(), brr(), i&, j As Byte, r&, k&, m&
- arr = Sheets("数据源").Range("A1").CurrentRegion.Value
- r = UBound(arr, 2) * UBound(arr) + UBound(arr) - 1
- ReDim brr(1 To 3, 1 To 1)
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If i Mod 2 = 1 Then
- m = m + 1
- ReDim Preserve brr(1 To 3, 1 To m)
- brr(1, m) = arr(i, j)
- Else
- brr(3, m - 5 + j) = arr(i, j)
- End If
- Next
- If i Mod 2 = 0 Then m = m + 1
- Next
- Sheets("希望的结果").Range("A1:C" & m - 1) = Application.Transpose(brr)
- End Sub
复制代码
|
|