Change how selected cells are shown in columns

[abjac]

HI Is there a easy way or with a macro to change, how columns are shown with data.
If i example have data in column A2:A10, forward in every column to example F2;F10
where header in A2 is lets say "start" and header in F2 is "end". With header in columns between
So all selected will go around so A2 is "end" and F2 is "start".
And include the date in the rows for the columns also.

See attached sheet

Sincerely

Abjac

[patel45]

are you sure you attached the correct file ?

[abjac]

Hi Patel. Yes its the correct on. I just have problem describe what i want to do. In this sheet it have to be changed between column B and column N. You can comepare the 2 results to see also. I make a little error in N3. In the first output. It should be January 2012. Sorry for that. But basically it have to be changed so from column B it comes from January 2012 and end in column N with january 2013, and the belonging rows have to follow off course. Hope i can explain it so its understandable.
Sincerely

Abjac

[abjac]

Hi Please see below test file i think its more easy to see what i want.

Thanks in advance

Abjac

[abjac]

HI It get solved by another thread thanks