How to combine many columns for different years into two columns

[Anonymous]

Hi guys,

I have a table with following columns:

Now, I want to create a line diagram with the years as x-axis to show the change of the price over the years.

My idea was to merge these columns into two columns "price" and "year", but I don't know how to do that.

Does someone of you have a solution how to handle this or even a more convenient approach to create the line diagram?

Best regards

[Anonymous]

Hi @Anonymous,

I think unpivot column should suitable for your scenario, you can refer to the following link to know more about this.

Unpivot columns (Power Query) 

If the above not help, can you please share a pbix file with some dummy data to test?

How to Get Your Question Answered Quickly

Regards,
Xiaoxin Sheng

[mhossain]

@Anonymous 

Select your all the number columns and Go to Transform in toolbar-- click Unpivot see below pic.

This will transform into two columns Attribute having column names, you can clean these to have year.

Second column you have your numbers.

Let me know if this solves.

[Anonymous]

No. No matter which columns I select to unpivot, I get errors in every cell.

[mhossain · Accepted solution]

@Anonymous 

If possible share the pbix with dummy data, we can have a look and send you back.

Or you can check if numbers columns are in number format.

[Anonymous]

Hi! The columns were not in number format. After I changed it, it worked. Thank you!