title: Create unique rows in excel with data in multiple columns
body: <p>I have multiple columns if data and I need to create unique rows for each LOC1 &amp; LOC2:
  Picture of mock-up:</p>
  
  <p><img src="https://i.stack.imgur.com/1krVQ.jpg" alt=""></p>
  
  <pre><code>LOC 1 LOC 2 FC      AMT Type
  CUN   ABQ   LLA0PNR 10  AN1
  CUN   AUS   BLA0PNR 15  NR2
  CUN   GSP   QLA0PNR 16  AN1
  CUN   DAL   HLA0PNR 14  NR2
  CUN   HOU   WLA0PNR 13  AN1
  CUN   ELP   RLA0PNR 12  AN3
  CUN   MDW   OLA0PNR 11  NR4
  </code></pre>
  
  <p>Create:</p>
  
  <pre><code>CUN ABQ LLA0PNR 10  AN1
  CUN ABQ BLA0PNR 15  NR2
  CUN ABQ QLA0PNR 16  AN1
  CUN ABQ HLA0PNR 14  NR2
  CUN ABQ WLA0PNR 13  AN1
  CUN ABQ RLA0PNR 12  AN3
  CUN ABQ OLA0PNR 11  NR4
  CUN     AUS     ......  ..      ...
  CUN     AUS     ......  ..      ...
  </code></pre>
  
  <p>A row would be built for each LOC1 and LOC2 with all values in FC, AMT, Type which are constant.   </p>