yes it is the same but the other thread is now in page 7 or 8 or something like that and I thought it was too far away to get an answer.

the row data always comes the same way. The only thing they don't give me and that I added my self is the column named Pit with all the 1s and 2s, ... which I added to help finding the data I wanted for my other macros.

I manually enter the values in L1:L6 so they will always be there yes.

the problem with formulas (that I understand as being excel code, not VBA) is that my row data is never quite the same. The number of different cars will change, the number of laps as well, the number of stints too.... and it is very very long to analysis manually, that's why I wanted macros.

And also I could be able to do with a manual pivot table but the chief engineer is using an older version of excel and fancy features are not really his thing....