Pivot Sales data to show true false if appearing in transaction

[Anonymous]

Hi, 

I currently have the below format of data:

I would like to get it to look like something like this:

I tried to pivot columns and it gave me this:

[jbwtp · Accepted solution]

Hi @Anonymous,,

Something like this?

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLKz8hTitWJVjICcRKTs8EcYyAnILE0B84Jy0zOrkSoy1eKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [incremental_id = _t, name = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"incremental_id", Int64.Type}, {"name", type text}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "incremental_id", "incremental_id - Copy"),
    #"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[name]), "name", "incremental_id - Copy", (x)=>List.ContainsAny(#"Duplicated Column"[#"incremental_id - Copy"], x))
in
    #"Pivoted Column"

Kind regards,

John