How to do that? colum data to registers

[ecabanas]

Hi all,

This is my first post, and I need your help.

I'm importing a table with dimensions on left and data per columns (january, february, etc). I uploaded the data to PBI but I want to import the data as a different way.

As you can see, I have dateid and values for revenues (ventas) cost , etc.
But I want to put every revenues, cost and margin in a table that has, concet (revenue, cost, etc) dateid and value. For example:

Any idea how to transpose the info in records?

Thanks

[ecabanas]

woow, thank you!!

[j_ocean · Accepted solution]

Highlight your dateid column and click "unpivot other columns" in the transform ribbon.