Symmetric transformation

 

Marios Mamzeris shows us that you can transform a odd square with sequencial numbers into a symmetric magic square in two steps (https://www.youtube.com/watch?v=JPEB8aT7XiU):

 

 

Step 1, horizontal swap

 

  1 2 3  >   3 1 2
  4 5 6     4 5 6
   < 7 8 9     8 9 7

 

 

Step 2, vertical swap

 

      ^          
  3 1 2     8 1 6
  4 5 6     3 5 7
  8 9 7     4 9 2
  v              

 

Download
3x3, symmetric transformation.xlsx
Microsoft Excel werkblad 8.4 KB