Bonjour,
Une autre proposition VBA.
Public Sub laplacea()
Dim tbl, arr()
Dim i As Long, j As Long, k As Long
Application.ScreenUpdating = False
With ActiveSheet.Cells(1)
tbl = .CurrentRegion.Value
.CurrentRegion.ClearContents
.Resize(, 10).Value = _
Array("Event Home", "Event Away", "FTHG", "FTAG", "Q1HG", "Q1AG", "Q2HG", "Q2AG", "Q3HG", "Q3AG")
For i = 2 To UBound(tbl)
'Si Event Part 5<>"" and Event Part 6<>""
If tbl(i, 15) <> "" And tbl(i, 16) <> "" Then
ReDim Preserve arr(10, k + 1)
arr(0, k) = tbl(i, 5) 'Event Home
arr(1, k) = tbl(i, 8) 'Event Away
arr(2, k) = Application.Sum(tbl(i, 11), tbl(i, 13), tbl(i, 15)) 'Event score 1
arr(3, k) = Application.Sum(tbl(i, 12), tbl(i, 14), tbl(i, 16)) 'Event score 2
arr(4, k) = tbl(i, 11) 'Event part 1
arr(5, k) = tbl(i, 12) 'Event part 2
arr(6, k) = tbl(i, 13) 'Event part 3
arr(7, k) = tbl(i, 14) 'Event part 4
arr(8, k) = tbl(i, 15) 'Event part 5
arr(9, k) = tbl(i, 16) 'Event part 6
k = k + 1
End If
Next i
With .Cells(2, 1).Resize(k, 10)
.Value = Application.Transpose(arr)
.EntireColumn.AutoFit
End With
End With
End Sub