title: Expanding column cells for each column cell
body: <p>I have 3 different sets of data (in different columns)  </p>
  
  <ol>
  <li>Animals (5 different kinds) in column A  </li>
  <li>Fruits (1000 different kinds) in column B  </li>
  <li>Countries (10 different kinds) in column C  </li>
  </ol>
  
  <p>With these 3 data collections I would like to receive 5×1000×10 for a total of 50k corresponding elements in col. E F G (each animal who corresponds with each fruit and each country).  </p>
  
  <p>It might be done by manually copying and pasting values, but it will take ages. Is there any way to automate it by VBA code or </p>
  
  <p>Is there any universal formula for unlimited data sets like the one presented above? Please let me know if something is not clear.</p>
  
  <p>Here is a smaller example of data and how the results should turn out:</p>
  
  <p>        <img src="https://i.stack.imgur.com/SIoag.jpg" alt="Expanding data sets for each in other"></p>