let
    Source = Excel.Workbook(File.Contents("C:\Users\Gebruiker\Downloads\voorbeeld-configurable-import.xlsx"), null, true),
    #"voorbeeld-configurable-import_Sheet" = Source{[Item="voorbeeld-configurable-import",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"voorbeeld-configurable-import_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"sku", Int64.Type}, {"attribute_set_code", type text}, {"pa_aankoppeling", type text}, {"product_type", type text}, {"product_online", Int64.Type}, {"tax_class_name", type text}, {"visibility", type text}, {"price", Int64.Type}, {"base_image", type text}, {"base_image_label", type any}, {"small_image", type text}, {"small_image_label", type any}, {"thumbnail_image", type text}, {"thumbnail_image_label", type any}, {"additional_images", type text}, {"additional_attributes", type text}, {"configurable_variations", type text}, {"qty", Int64.Type}, {"product_websites", type text}, {"name", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"configurable_variations"}),
    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Custom", each "sku=" & Text.From([sku]) & "," & Text.From([additional_attributes])),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Transposed Table" = Table.Transpose(#"Removed Other Columns"),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Transposed Table", {{"Column66", type text}}, "en-US"),{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25", "Column26", "Column27", "Column28", "Column29", "Column30", "Column31", "Column32", "Column33", "Column34", "Column35", "Column36", "Column37", "Column38", "Column39", "Column40", "Column41", "Column42", "Column43", "Column44", "Column45", "Column46", "Column47", "Column48", "Column49", "Column50", "Column51", "Column52", "Column53", "Column54", "Column55", "Column56", "Column57", "Column58", "Column59", "Column60", "Column61", "Column62", "Column63", "Column64", "Column65", "Column66"},Combiner.CombineTextByDelimiter("|", QuoteStyle.None),"Merged")
in
    #"Merged Columns"