Dynamically merge specific columns without null and output as text

Hi vc25 pls remove the highlighted lines

Since Changed Type 3 already converts fish columns to text, you can just add the merge step after that and it will show values instead of table.

AddMergedLabels =
        Table.AddColumn(
            #"Changed Type3",
            "merge",
            each
                Text.Combine(
                    List.RemoveNulls(
                        List.Transform(
                            List.Select(
                                Table.ColumnNames(#"Changed Type3"),
                                each Text.StartsWith(_, "fish")
                            ),
                            (c) => Record.Field(_, c)
                        )
                    ),
                    ";"
                ),
            type text
        )
in
    AddMergedLabels