title: How to format rows of secound column concidering rows of first column
body: <p>How to format rows of secound column considering rows of first column.</p>
  
  <p>Description::-</p>
  
  <p>I have One column say column A in excel with 8 rows.</p>
  
  <p>data is present in some rows and blank for some rows.
  eg</p>
  
  <pre><code>1st row tiger
  2nd row lion
  3rd row (blank no data present)
  4th row (blank no data present)
  5th row cow
  6th row (blank no data present)
  7th row cat
  8th row mouse.
  </code></pre>
  
  <p>Now my secound column say B in excel contains data in 85 rows consecutivly.
  eg</p>
  
  <pre><code>1st row 1
  2nd row 1
  3rd row 3
  4th row 4
  5th row 10
  </code></pre>
  
  <p>Now i want to arrange the 2nd column according to the 1st column.</p>
  
  <p>like below:</p>
  
  <pre><code>column A                            Column B
  1st row tiger                       1
  2nd row lion                        1
  3rd row (blank no data present)
  4th row (blank no data present)
  5th row cow                         3
  6th row (blank no data present)
  7th row cat                         4
  8th row mouse.                      10
  </code></pre>
  
  <p>Since I have huge volume of data, I need a formula to do that.</p>
  
  <p>Please suggest for the same.</p>