|
发表于 2021-11-24 08:55
|
显示全部楼层
本楼为最佳答案
本帖最后由 心正意诚身修 于 2021-11-24 08:57 编辑
- Sub 数据转置()
- Dim data, arr(), i As Integer, j As Integer, k As Single
- data = Sheets("A").Range("d4:gn300").Value
- ReDim arr(1 To 16370)
- For i = 1 To UBound(data)
- For j = 1 To UBound(data, 2)
- If data(i, j) <> "" Then
- k = k + 1
- arr(k) =data(i, j)
- End If
- Next
- Next
- Sheets("C").Range("d2").Resize(1, k) = arr
- Sheets("C").Range("b4").Resize(k, 1) = Application.Transpose(arr)
- End Sub
复制代码 |
评分
-
查看全部评分
|