Combine data

Hello khteng79 

This is the required M-code to achieve the same requirement.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRyVnDOzy1IzKtU0lHyDXZSCAgHMpz93dxcXRV8gczgEEc/F1dXIMvAWMHJNcw1yNEdxDM0NjY0MTG1NDUxNLA0MjU2NFCK1aGigabmQANjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Customer_Name = _t, Q1 = _t, Q2 = _t, Q3 = _t, Q4 = _t, ID = _t]),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"),
    #"Transposed Table" = Table.Transpose(#"Unpivoted Columns"),
    #"Removed Columns" = Table.RemoveColumns(#"Transposed Table",{"Column7", "Column8", "Column9", "Column10", "Column11"}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Columns", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Customer_Name", type text}, {"Q1", type text}, {"Q2", type text}, {"Q3", type text}, {"Q4", type text}, {"ID", type text}, {"ID_1", type text}})
in
    #"Changed Type"

Thank you.
If my answer helps you, please mark it as solution.