Hello, our golf club has a golf competition with difficult rules. Every
member can play once a week a result and you have approximately 16 weeks time
to improve your score (the sum of your 4 best results). Caddiemasters publish
every second week data of participants´ results and to know situation
(rankings) I have to rearrange data. And it´s boring to repeat some
activities in excel. I can write macros, but now I have to learn a little bit
more.

The data range is every time varying with its width and lenght. The width
varies based on the fact that week amount is raising. The lenght varies based
on amount of players is changing. Macro has to understand, how long the data
range is (calculate row amount, I suppose or understand the number of the
lowest row). Then macro copies first A column with players names and first
week column B, transport the data range to a new data sheet, then copy again
first A column and second week column C and transport the data range to
continut the new data sheet´s pivotable database and so on till we have
played weeks.