|
发表于 2021-3-30 15:30
来自手机
|
显示全部楼层
Sub Transpose()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Range("e2").CurrentRegion.Offset(1).ClearContents
Cells(2, 5).Value = Cells(2, 1).Value
Cells(2, 6).Value = Cells(2, 2).Value
Cells(2, 7).Value = Cells(2, 3).Value
k = 8
For i = 3 To Range("a1").CurrentRegion.Rows.Count
For j = 2 To Range("e1").CurrentRegion.Rows.Count
If Cells(i, 1).Value = Cells(j, 5).Value Then
Do While Cells(j, k).Value <> ""
k = k + 2
Loop
Cells(j, k).Value = Cells(i, 2).Value
Cells(j, k + 1).Value = Cells(i, 3).Value
k = 8
Exit For
ElseIf Cells(j + 1, 5) = "" Then
Cells(j + 1, 5).Value = Cells(i, 1).Value
Cells(j + 1, 6).Value = Cells(i, 2).Value
Cells(j + 1, 7).Value = Cells(i, 3).Value
End If
Next j
Next i
End Sub |
评分
-
1
查看全部评分
-
|