|
发表于 2016-3-10 10:31
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- arr = Range("a2:h11")
- ReDim brr(1 To UBound(arr) * UBound(arr, 2), 1 To 2)
- For i = 2 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- If Len(arr(i, j)) > 0 Then
- n = n + 1
- brr(n, 1) = arr(i, 1) & "/" & arr(1, j)
- brr(n, 2) = arr(i, j)
- End If
- Next
- Next
- [J3].Resize(n, 2) = brr
- End Sub
复制代码 |
|