Repeat Row N Times

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-
- - - - Blog - - - -

[rupeshpandey]

We also can do that by adding custom column and write simple code {1..[value]} and expanding that give us same result. By the way i am your big fan.

[wesleyrenton]

You just saved me A LOT of time! Thank you!

[nikhilbudhiraja]

Thanks! you saved a lot of manual effort.

[uweseidel]

Woohoo! Exactly what I was looking for. Thanks, mate!

[fjdiazt]

Amazing! very clear and to the point, and the way you explain each step in detail helps a lot! thank you.

[triantafyllosmarangos]

Excellent, it's Very nice your job. Thank you very much for share with us!

[marcelofilms]

Excellent demonstration! Thank you very much for share with us!

[ExceliAdam]

I tried:
Text.Combine(List.Repeat({[Attribute]}, [Value]), ";")
then Split by ";" to Rows.

Thanks for the inspiration

[LTV_GOD]

Great example! much appreciate! that is what i was looking for

[davidhollingsworth]

Cheers Goodly, you're the man, been looking for this for ages

[oh]

Thank you words perfectly, Subscribed :)

[tecwzrd]

Thank you very much for this tutorial. I had manually been duplicating lines by X amount of times through a VBA script but this way is much quicker :)

[rajudongang]

Superb.
Hey can you help me to repeat selected rows at top as well as on bottom of the page on each printing page?

[shoaibrehman]

Very useful video, why can't view in Playlist as a Powe Query in your channel

[meditatereflect]

Hi.. I have 250k rows of data and I want to repeat that Ntimes but adding date to 1 column )incremental) Ex, . The first 250klines with date June 5 and the next duplicated 250 rows will have new date June 6 and so on.. how can I do that in pquery?

[demetriusc]

is there a way to do this with google sheets?