Power Query - Transpose unique values and get matching values in rows
<p>I am trying to transform a very simple input_table</p>

<p><a href="https://i.stack.imgur.com/rZtMR.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rZtMR.jpg" alt="enter image description here"></a></p>

<p>into this output_table:</p>

<p><a href="https://i.stack.imgur.com/h9tDo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h9tDo.jpg" alt="enter image description here"></a></p>

<p>I am basically trying to:</p>

<ul>
<li>Get unique items in first column</li>
<li>Transpose and promote these items as column headers</li>
<li>Get matching values (from the second column in <strong>input_table</strong>) under each unique header</li>
</ul>

<p>I am using Power Query because I need the <strong>output_table</strong> to dynamically update each time I add records to <strong>input_table</strong>, but any other dynamical solution is accepted (Array Formulas, intermediate Tables, etc...). No VBA.</p>