a solution need to repeat value in cell for specific count

[ANKUSHRS1]

Hi friends,

I am seeking your help for one solution as describe in excel attachment..

 

[Khalid NGO]

Hi,

Power Query Solution:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Typed = Table.TransformColumnTypes(Source,{{"NAME", type text}, {"REPT", Int64.Type}}),
    Repeated = Table.TransformColumns(Typed, {"REPT", each List.Numbers(_,_,0), type list}),
    Expanded = Table.ExpandListColumn(Repeated, "REPT"),
    #"Removed Columns" = Table.RemoveColumns(Expanded,{"REPT"})
in
    #"Removed Columns"

Regards,

 

[bosco_yip]

Perhaps……..

In A2, copied down :

=LOOKUP(ROW(A1)-1,MMULT(N(ROW($1:$5)>COLUMN(A:D)),E$2:E$5),D$2:D$5)&""

Regards
Bosco

 

[GraH - Guido]

Hi,

Power Query Solution:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Typed = Table.TransformColumnTypes(Source,{{"NAME", type text}, {"REPT", Int64.Type}}),
    Repeated = Table.TransformColumns(Typed, {"REPT", each List.Numbers(_,_,0), type list}),
    Expanded = Table.ExpandListColumn(Repeated, "REPT"),
    #"Removed Columns" = Table.RemoveColumns(Expanded,{"REPT"})
in
    #"Removed Columns"

Regards,

Hi Khalid,

There is an alternative, in my eyes more readable, way via PQ...
Add a column with this formula: List.Repeat({[NAME]},[REPT])

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ChangeType = Table.TransformColumnTypes(Source,{{"NAME", type text}, {"REPT", Int64.Type}}),
    MakeListRepeat = Table.AddColumn(ChangeType, "List", each List.Repeat({[NAME]},[REPT])),
    ExpandList = Table.ExpandListColumn(MakeListRepeat, "List"),
    RemoveOtherCols = Table.SelectColumns(ExpandList,{"List"})
in
    RemoveOtherCols

 

[Khalid NGO]

There is an alternative, in my eyes more readable, way via PQ...
Add a column with this formula: List.Repeat({[NAME]},[REPT])

Hi G,

Awesome.
Thanks for sharing.

Regards,

 

[GraH - Guido]

No worries, with pleasure.