Display value by step

Hi guenfood ，

Based on your description, I think you can convert that table in power query first and then merge the two columns. I did the test with the following reference:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hY29CsMwDIRfRXgO9Ic+QUuHTh0zhAzGFqmJLQXJpj9PXxMouEs7iAPd3XfDYPpAnu9qOrM7bLb7qsdYENQJIjXfj544LREzejN2gzk/HMbGTdYJg+biZmCCaAu5219Kz+K/ICFCQpkQUISlsaDehWARngRV1/a15Mg8NyliwBWizzovTOFlc2D6BRrf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Service = _t, Date = _t, Problem = _t, #"Start Date" = _t, #"End Date" = _t, Status = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Service", type text}, {"Date", type text}, {"Problem", type text}, {"Start Date", type text}, {"End Date", type text}, {"Status", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value"),
    #"Added Custom" = Table.AddColumn(#"Unpivoted Columns", "list_", each [Attribute] & ":" & [Value]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Attribute", "Value"})
in
    #"Removed Columns"

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.