title: Swap data from the same table
body: <p>I need some help with a query that allows me to swap data in the same column like this:</p>
  
  <pre><code>ID    Name     Notebook Sales  Pen Sales
   1     33             2             3
   2     33             5             6
   3     5              8             9
   4     7              2             3
   5     35             5             6
   6     35             8             9
  
  ID    Name     Notebook Sales  Pen Sales
   1     35             2             3
   2     35             5             6
   3     5              8             9
   4     7              2             3
   5     33             5             6
   6     33             8             9
  </code></pre>
  
  <p>In this example i swapped the name '33' for the name '35' keeping the original info of each one.</p>
  
  <p>I'm working with 5000+ rows so doing something one by one gonna take a while.</p>
  
  <p>The only way i thougth was switching the ones with the name '33' to '35' but then im gonna end with something like this:</p>
  
  <pre><code>ID    Name     Notebook Sales  Pen Sales
   1     35             2             3
   2     35             5             6
   3     5              8             9
   4     7              2             3
   5     35             5             6
   6     35             8             9
  </code></pre>
  
  <p>and then they are going to mix making dificult to change the first '35' ones to '33'.</p>
  
  <p>Hope you can help me out with this and thanks in advance.</p>