Forum Discussion
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 receive it in the format shown below. Could you please assist me?
| ID | Package |
| 1 | [barcode1] |
| 1 | [barcode2] |
| 2 | [barcode1] |
| 2 | [barcode2] |
| 2 | [barcode3] |
| 3 | [barcode1] |
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
2 Replies
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 result2 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 Groupconsider 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
