Hi
I have cols A1 to G1 with values in them. This data is automatically fed into the spreadsheet from a data source. These represent daily figures. I need to change the order of appearance from G1 to A1. Bear in mind that sometimes the number of cols can increase and can decrease too.
I have labeled above each col the WEEKNUM that the data applies to because the data is summed on a weekly basis.

This new order has to appear in sheet 2. How do i do this.

Thanks