Two columns out of a column

[Fragan]

Hey,

I have a table with several column named like this "COLUMN_NAME YEAR-MONTH", i want to create two separate columns, "COLUMN_NAME" and "YEAR-MONTH" here's an example :

CM 2019-01	CM 2019-02
232.232	9123.222

I want to make it like this :

Column_name	date	value
CM	2019-01	232.232
CM	2019-02	9123.222

Is there anyway i can achieve that with power query?

Regards

[amitchandak]

You need to transpose first. Refer :https://radacad.com/pivot-and-unpivot-with-power-bi

[danno · Accepted solution]

Try Transpose first, then you can split your columns using the built in features of powerquery, perhaps use add column from examples to make the process even easier