title: How do I create a table in excel based on 2 values in another table
body: <p>Hi I want to generate values in a table based on 2 values in another table. It's difficult to explain this problem in words so I will attempt to explain it with an example.
  Example: data in table 1 needs to be used to populate values in table 2 </p>
  
  <p>Table 1:</p>
  
  <pre><code>Building type             Number
  Hospital                     4           
  Fire station                 2
  Hotel.                       0
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>Hospital 1
  Hospital 2
  Hospital  3
  Hospital  4
  Fire station 1
  Fire station 2
  </code></pre>
  
  <p>Note if the number is 0 in column 2 of table 1, no corresponding value should be created in table 2.</p>