title: Ordering the third column in excel according to first column (and fill blanks)
body: <p>I have three columns, two first columns have identical values, the third one has some values missing (below nr. 2 &amp; 4 are missing).</p>
  
  <p>So how can I "order" these:</p>
  
  <pre><code>+---+---+---+
  | A | B | C |
  +---+---+---+
  | 1 | 1 | 1 |
  | 2 | 2 | 3 |
  | 3 | 3 | 5 |
  | 4 | 4 |   |
  | 5 | 5 |   |
  +---+---+---+
  </code></pre>
  
  <p>To become:</p>
  
  <pre><code>+---+---+---+
  | A | B | C |
  +---+---+---+
  | 1 | 1 | 1 |
  | 2 | 2 | 0 |
  | 3 | 3 | 3 |
  | 4 | 4 | 0 |
  | 5 | 5 | 5 |
  +---+---+---+
  </code></pre>
  
  <p>As you can see, the values that are missing are being (i.e. <strong>should be</strong>) filled with zero.
  The numbers above are unique (i.e. I can't have two 4's in the same column). So how can I get the same values from Column C to be right next to column B (and then I can fill the empty fields with zero).</p>