Turn matrix list to csv friendly list

[Khaazh]

I have a issue where i need to a matrix list into a csv friendly list.

The first to coloums indicate the customer and the part number.
The row header indicates the date where they forecast a need.

But i need to turn it into a csv friendly format like "customer";"part #";"date";"amount".

The source data is retrived from an html fil with power query.

Updated with attached example with before and after.

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
(there is nothing attached in your post)

[sandy666]

the file is attached incorrectly

at the top of the page is instruction HOW TO ATTACH

[Czeslaw]

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Customer", "Part #"}, "Attribute", "Value"),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Unpivoted Other Columns", {{"Attribute", type date}}, "da-DK"),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type with Locale",{{"Attribute", "Date"}, {"Value", "Sum"}})
in
    #"Renamed Columns

"

[Khaazh]

Thank you, this solved my issue

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Customer", "Part #"}, "Attribute", "Value"),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Unpivoted Other Columns", {{"Attribute", type date}}, "da-DK"),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type with Locale",{{"Attribute", "Date"}, {"Value", "Sum"}})
in
    #"Renamed Columns

"