bonsoir,
une proposition, qui se base sur ta mise en page.
Sub aargh()
a = Range("A2:A7")
col = 4
m = 6
j = 1
cp = 1
While j <= 15
For i = 1 To 3
cp = cp + 1
col = col + 2
If col > 10 Then col = 6: m = m + 1
If j Mod 2 = 0 Then
Cells(m, col) = a(i, 1) & " " & a(i + 3, 1)
Else
Cells(m, col) = a(i + 3, 1) & " " & a(i, 1)
End If
If j <= 10 Then Cells(cp, 4) = Cells(m, col)
Next i
Select Case (j Mod 3)
Case 1
Range(Cells(m, 6), Cells(m, 10)).Cut Cells(m, 8)
Cells(m, 12).Cut Cells(m, 6)
Case 2
Range(Cells(m, 6), Cells(m, 10)).Cut Cells(m, 10)
Range(Cells(m, 12), Cells(m, 14)).Cut Cells(m, 6)
End Select
y = a(2, 1)
a(2, 1) = a(3, 1)
a(3, 1) = a(6, 1)
a(6, 1) = a(5, 1)
a(5, 1) = a(4, 1)
a(4, 1) = y
j = j + 1
Wend
For i = 8 To 18 Step 5
Cells(i, 6).Cut Cells(i, 7)
Next i
Columns("k").Delete shift:=xlToRight
End Sub