Make row values as Header

Hi MORDax ,

You can use the Table.Pivot function in Power Query to achieve what you want. Here's sample M Script that shows this capability.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwUNJRCkktLklNATIMDPWByMjAyEgpVgcmG5Wfh1syIDE5G7usIYrBRlhk4QZjk0QYjC5rhNdgI3wGG+EyOBYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Col A" = _t, #"Col B" = _t, #"Col C" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Col A", Int64.Type}, {"Col B", type text}, {"Col C", type date}}),
    Custom1 = Table.Pivot(#"Changed Type", {"Tested", "Zoned", "Packed"}, "Col B", "Col C")
in
    Custom1