The problem is that the actual table is more complicated and has more than 50 columns.. I think I am not able to write this macro on my own, but providing you dummy data isnt possible because I am not allowed to say anything - not even the name of the columns... All I can say is: it is about cars.
I think I have to continue with copy paste and hope that this work will be done in one or two years.... But thank you for trying to help.
Maybe I am going to read the links you gave me and try a bit on my own when I have some time left.