Forum Discussion

Sylbaryn's avatar
Sylbaryn
New Member
2 years ago
Solved

How can I split a column of data into 2 columns, based on the value of another column

Hi. My data only has two columns. A Product Number and a Customer Number. Each product must have either one or two associated customers and a customer can have as many products as they want. My aim ...
Need Help
ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago

For arbitary count of columns,

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQAAiUdJVMDpVgdJK4hnGsI4hrBuUYgrjEq1wSFa2lpic5HCBiD1Juics3gXBNUrimqXaZQu2IB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Product Number" = _t, #"Customer Number" = _t]),
    #"Grouped by Prod Num" = Table.Group(Source, "Product Number", {"Prod", each [Customer Number]}),
    Columns = {#"Grouped by Prod Num"[Product Number]} & List.Zip(#"Grouped by Prod Num"[Prod]),
    #"To Table" = Table.FromColumns(Columns)
in
    #"To Table"

Sylbaryn's avatar
Sylbaryn
New Member
2 years ago

Thank you very much