Relationship between original and transposed table

[Evaldes]

I would like to stablish a relation between a table and its transposed version, linked by the variable "Estación"

The original table is this:

And this is the transposed version:

As you can see, the variable "Estación" disappeard in the transposed table, and became the column headers. Is there any way to relate this tables?

I would really appreciate your help

[Icey]

Hi @Evaldes ,

Why do you want to transpose the table and link the two tables? What's your purpose? Maybe we can find another more suitable method.

Best Regards,

Icey

[amitchandak · Accepted solution]

@Evaldes , I would prefer to unpivot the tables then transpose, so both year and Estación are in rows.

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