title: How to mass transpose and merge multiple xls files?
body: <p>I have more than 30 seperate .xls files similar to this:</p>
  
  <p><strong>.xls 1:</strong></p>
  
  <pre><code>a   11  22  33  54
  b   2   44   4  5
  c   3   4    5  3
  </code></pre>
  
  <p><strong>.xls 2</strong></p>
  
  <pre><code>a   12  22  35  58
  b   2   44   4  5
  c   3   4    5  3
  </code></pre>
  
  <p>I want to <strong>transpose and merge</strong> them (possibly through Power Query?), so they look like this:</p>
  
  <pre><code>a     b    c
  11    2    3
  22    44   4
  33    4    5
  54    5    3
  12    2    3
  22    44   4
  35    4    5
  58    5    3
  </code></pre>
  
  <p>How do I make this? Thank you very much.</p>