Convert multiple columns of records into One columns of rows.

[Chachi]

Good afternoon,

Could anyone help with this, please? I have the table below in my power BI. The rates are recorded in different columns, and I want to combine them under one column using the headers as records in a different column. There are more columns in this table that I haven't Included in this table, but I don't want to lose any records associated with each ID. 

I want to convert it to this format. Any help would be highly appreciated. 

Thank you very much.

[HotChilli]

Select the 3 rate columns and Unpivot.
That will put them in one column.

You can filter out the empty rows from that column if required.