Sub transpose()
Dim r As Range
Dim c As Range
Set r = _
Intersect(Columns("A"), ActiveSheet.UsedRange)
For Each c In r
c.Resize(, 3).Copy
Cells(65536, 4).End(xlUp).Offset(1, 0).PasteSpecial xlAll, xlNone, False, True
Next
Columns("A:C").Delete
Rows("1:1").Delete
End Sub
Tu peux pas ! C'est pour le funComment tu fais à la mano (en une seule passe) la transposition ?
Sub TranspositionII()
Dim i&, j&, dc&, dl&, l_tpo&, r As Range, rr As Range
Set r = _
Range("A1").CurrentRegion
dc = _
r.Columns.Count
dl = _
r.Rows.Count
l_tpo = _
dl + 2
For i = 1 To dc
For j = 1 To dl
Cells(l_tpo, 1) = Cells(i, j)
l_tpo = l_tpo + 1
Next
Next
Set rr = _
Range(Cells(dl + 2, "A"), _
Cells([A65536].End(xlUp).Row, _
"A")).SpecialCells(xlCellTypeBlanks)
rr.EntireRow.Delete shift:=xlUp
End Sub