title: Notepad++ or Excel: transpose two columns, batch for multiple files
body: <p>I have multiple .txt files in the form of</p>
  <pre><code>Name1|number1
  Name2|number2
  Name3|number3
  (...)
  </code></pre>
  <p>And I would need to transpose them to look like:</p>
  <pre><code>Name1|Name2|Name3|(...)
  Number1|Number2|Number3|(...)
  </code></pre>
  <p>This is easy enough to do for a single file in excel, but I would need a way to do this in multiple files in a folder. Since Notepad++ allows finding and replacing for multiple files, I would like to know if there is a way to achieve this somewhat automatically.</p>
  <p>While all files have the same pattern (two columns), <strong>not</strong> all of them have the same number of rows.</p>
  <p>I have tried the following aproaches using Notepad++:</p>
  <ul>
  <li>Replacing <code>|</code> for a carriage return to have everything in a single column, in hopes to somehow group all numbers, move them to the bottom and reorganize.</li>
  <li>Repeat the whole text below using a symbol to separate both copies (find <code>[\s\S]*.*</code>, replace with <code>\0\n%\n\0</code>), in an attempt to delete all numbers above and all names| below to finally reorganize. Also got stuck in the middle.</li>
  </ul>
  <p>As you can see, my Regex knowledge is extremely limted, even using Regex101. I don't know if this is easy or hard to achieve, I simply cannot find the solution by myself after several hours.</p>
  <p>What can I do?</p>
  <p>Thanks for your patience in advance.</p>