Need help to create table

[mervetitirinli]

Could you please help me to create table in the photo?

[v-zhangti]

Hi, @mervetitirinli 

You can try the following methods.
Power Query-Transform-Transpose:

Result:

Is this the result you expect? What is the logic of the other table, can you explain?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mervetitirinli , You need to unpivot the table 2 for that in power query and then use it

https://radacad.com/pivot-and-unpivot-with-power-bi

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.