用宏做比较简单:Sub yueliang()Dim i, j, l, k, m As Integerm = Range("A65536").End(xlUp).Rowk = 1For i = 2 To 9
For j = 1 To 5 Step 2
Sheets(2).Cells(1, k) = Sheets(1).Cells(i, j)
k = k + 1
NextNextFor l = 0 To m Step 11k = 1
For i = 2 To 9
For j = 2 To 6 Step 2
Sheets(2).Cells