Need help to create table

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.