Transpose column from table to a different table as a row

Question

Hi All,&nbsp;I'm new to Power BI functionality and I'm stuck with a simple task (as I think).&nbsp;I have table A with the following structure:&nbsp;Type&nbsp; &nbsp; &nbsp; &nbsp;Inst X&nbsp; &nbsp; &nbsp; InstY&nbsp; &nbsp; Inst Ztype1&nbsp; &nbsp; &nbsp; &nbsp; 123&nbsp; &nbsp; &nbsp; 123&nbsp; &nbsp; &nbsp; &nbsp;123&nbsp;And I have table B:&nbsp;Type 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValueInst X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 235Inst Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 235&nbsp;Inst Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 235&nbsp;&nbsp;&nbsp;So what&nbsp; I'm trying to achieve is create some sort of Union with the transpose of Table B and insert the values from Table B to table A:&nbsp;Type&nbsp; &nbsp; &nbsp; &nbsp;Inst X&nbsp; &nbsp; &nbsp; InstY&nbsp; &nbsp; Inst Ztype1&nbsp; &nbsp; &nbsp; &nbsp; 123&nbsp; &nbsp; &nbsp; 123&nbsp; &nbsp; &nbsp; &nbsp;123type2&nbsp; &nbsp; &nbsp; &nbsp; 235&nbsp; &nbsp; &nbsp; 235&nbsp; &nbsp; &nbsp; &nbsp;235&nbsp;Any ideas on how to achieve this?&nbsp;Thanks!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;