Transpose column from table to a different table as a row

[Diana_V]

Hi All,

I'm new to Power BI functionality and I'm stuck with a simple task (as I think).

I have table A with the following structure:

Type       Inst X      InstY    Inst Z

type1        123      123       123

And I have table B:

Type 2         Value

Inst X            235

Inst Y            235 

Inst Z            235 

So what  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:

Type       Inst X      InstY    Inst Z

type1        123      123       123

type2        235      235       235

Any ideas on how to achieve this?

Thanks!

[pawel1 · Accepted solution]

both tables contain similar data, you want to combine both tables into ONE, something like this:

How to do this?

1. UNPIVOT both tables in Query Editor:

 

2. Align Column Titles

3. Combine both tables with APPEND

Ready, now you can visulize with Matrix