Repeat Row N Times

Check out our newly launched M Language course ↗️ - goodly.co.in/l...
Repeat rows n times using power query. Download excel file here - www.goodly.co....
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - - Blog - - - -
www.goodly.co....

[@GoodlyChandeep]

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

[@rupeshpandey9878]

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.

[@tifsthirdpartylogistics5316]

Thank you for Sharing!!! ^_^

[@rajudongang07]

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

[@GoodlyChandeep]

I think there is an option when you print (Ctrl P) >> under page setup >> sheet tab, which allows you to select rows to be printed

[@meditatereflect3354]

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?

[@triantafyllosmarangos4120]

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

[@oh6254]

Thank you words perfectly, Subscribed :)

[@GoodlyChandeep]

Thanks :)

[@marcelo157films]

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

[@GoodlyChandeep]

Marcelo Ferreira glad you liked it :)

[@Fiktage]

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

[@Fiktage]

just recently found even more simple way: to add custom column {1..[Value]}, then expend list

[@GoodlyChandeep]

Super! Can you please share the code here (in the comments) - www.goodly.co.in/repeat-row-n-times/

[@mamavgaming8861]

Thank you so much for this tutorial!

[@uweseidel8784]

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

[@nikhilbudhiraja5882]

Thanks! you saved a lot of manual effort.

[@wesleyrenton3571]

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

[@fjdiazt]

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

[@GoodlyChandeep]

Glad it was helpful!

[@demetriusc6207]

is there a way to do this with google sheets?

[@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 :)

[@GoodlyChandeep]

Glad it benefited !

[@alok21prakash]

how to reverse please guide

[@nikosuomi5674]

Genius!

[@davidhollingsworth5608]

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

[@GoodlyChandeep]

haha.. Thanks David!
My name is Chandeep but the channel is Goodly :D

[@shoaibrehman9988]

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

[@GoodlyChandeep]

Thanks Ali, I'll collate all of the Power Query Videos in a single playlist

[@shoaibrehman9988]

Gr8

[@ExceliAdam]

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