Merge rows with delimiter

Not sure if this will help but this is how I do it, replace the bold text with your specific data and paste into advanced editor at the correct point. Step3 seperates the answers into different columns so delete that if you want them in the same column.

This example would create a single line for each ItemCode (Name) and multiple columns for each Ink (Cake) 

Splitting multiple Rows into sperate columns based on a header i.e. ItemCode and Inks

    #"SplitStep1" = Table.Group(#"PreviousStep", {"ItemCode"}, {{"Count", each Table.RowCount(_), type number},{"Inks", each Text.Combine([Inks],","), type text}}),

    Columns = List.Transform({1..List.Max(#"SplitStep1"[Count])}, each "Inks."&Text.From(_)),

    #"SplitStep2" = Table.SplitColumn(#"SplitStep1", "Inks", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), Columns),

    #"SplitStep3" = Table.RemoveColumns(#"SplitStep2",{"Count"})

Thanks,

Jamie666stuck Paste this in the advanced editor:

let
    Source = Table.FromRows (
        Json.Document (
            Binary.Decompress (
                Binary.FromText (
                    "i45W8spPVdJRciwoyAHRwQX5eekghlNicn6eUqwOTAEQuSVmFlWCmCBR38xsiLI8IAQynDPyk/NzEktSwezM5OzUPGR1vol56flAOiwxLzMnJxFsSiwA",
                    BinaryEncoding.Base64
                ),
                Compression.Deflate
            )
        ),
        let
            _t = ( ( type nullable text ) meta [ Serialized.Text = true ] )
        in
            type table [ Name = _t, Fruit = _t, Cakes = _t, Meat = _t ]
    ),
    ChangedType = Table.TransformColumnTypes (
        Source,
        {
            { "Name", type text },
            { "Fruit", type text },
            { "Cakes", type text },
            { "Meat", type text }
        }
    ),
    GroupedRows = Table.Group (
        ChangedType,
        { "Name" },
        {
            {
                "Transformation",
                each Table.FromRows (
                    {
                        List.Transform (
                            Table.ToColumns ( Table.RemoveColumns ( _, "Name" ) ),
                            each Text.Combine ( List.RemoveItems ( _, { "" } ), "; " )
                        )
                    },
                    type table [ Fruit = text, Cakes = text, Meat = text ]
                ),
                type table [ Fruit = text, Cakes = text, Meat = text ]
            }
        }
    ),
    ExpandedTransformation = Table.ExpandTableColumn (
        GroupedRows,
        "Transformation",
        { "Fruit", "Cakes", "Meat" },
        { "Fruit", "Cakes", "Meat" }
    )
in
    ExpandedTransformation