Duplicate Rows

[Anonymous]

Hello All,

I have the dataset as the following:

Part Number           Item description

026 48202 000        Catridge

026 35601 000         Oil

I need duplicate both the columns by four same rows . I have attached the screenshot of the final result.Any help will be appreciated.

Thank You

Iva

[AlexisOlson]

You can define a new custom column as a list {1,2,3,4} or, equivalently, {1..4} and then expand that new column by clicking the expand button: 

Add column:

Expand column:

[AlexisOlson]

I don't see any screenshots.

[Anonymous]

[MBreden · Accepted solution]

try this query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjAyUzCxMDIwUjAwMFDSUXJOLCnKTElPVYrVgUgam5oZGEIl/TNzlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Part Number" = _t, #" Item description" = _t]),
    GroupRows = Table.Group(Source, {"Part Number"}, {{"All", each _, type table}}),
    CustomRepeat = Table.AddColumn(GroupRows, "Repeat", each Table.Repeat([All],4)),
    RemoveOtherColumns = Table.SelectColumns(CustomRepeat,{"Repeat"}),
    Expand = Table.ExpandTableColumn(RemoveOtherColumns, "Repeat", {"Part Number", " Item description"}, {"Part Number", " Item description"})
in
    Expand

 /Melanie