Swap ranges  
 
This tool allows you to interchange data contained in two ranges, in a simple manner.
Have a look at the example:
The blue ranges are to be interchanged.
 
 
Once you have selected the ranges to interchange, just press the OK button.
 
 
That is all!