Forum Discussion

michal_boro's avatar
michal_boro
Frequent Visitor
1 year ago
Solved

How to multiply rows depending on the results

Hi i ve got data as shown in the example below ID Package  1 [barcode1], [barcode2],  2 [barcode1], [barcode2], [barcode3] 3 barcode1]   And using Power Query, I would like to r...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    consider your data as below

     

    select Package column and go to home tab and select split column and make the below changes over it

     

     

    press ok to find the result as below


    finally filter blank cellls

ZhangKun's avatar
ZhangKun
Super User
1 year ago

1 to 2

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUYpOSixKzk9JNYzVUYCxjWKVYnWilYxwSiPYxhClxihKlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Package = _t]), 
    result = Table.ExpandListColumn(Table.TransformColumns(Source, {"Package", each List.Transform(Text.Split(_, ","), Text.Trim)}), "Package")
in
    result

2 to 1

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUYpOSixKzk9JNYxVitVBFTKCCBlhqjLCr8oYImSMpjEWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Package = _t]),
    Group = Table.Group(Source, {"ID"}, {{"Package", each Text.Combine(_[Package], ","), Int64.Type}})
in
    Group