Repeat Row N Times
HTML-код
- Опубликовано: 11 сен 2024
- 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....
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
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.
You just saved me A LOT of time! Thank you!
Thanks! you saved a lot of manual effort.
Amazing! very clear and to the point, and the way you explain each step in detail helps a lot! thank you.
Glad it was helpful!
Woohoo! Exactly what I was looking for. Thanks, mate!
Thank you so much for this tutorial!
Excellent demonstration! Thank you very much for share with us!
Marcelo Ferreira glad you liked it :)
Great example! much appreciate! that is what i was looking for
just recently found even more simple way: to add custom column {1..[Value]}, then expend list
Super! Can you please share the code here (in the comments) - www.goodly.co.in/repeat-row-n-times/
Excellent, it's Very nice your job. Thank you very much for share with us!
Cheers Goodly, you're the man, been looking for this for ages
haha.. Thanks David!
My name is Chandeep but the channel is Goodly :D
I tried:
Text.Combine(List.Repeat({[Attribute]},[Value]),";")
then Split by ";" to Rows.
Thanks for the inspiration
Thank you for Sharing!!! ^_^
Thank you words perfectly, Subscribed :)
Thanks :)
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 :)
Glad it benefited !
Superb.
Hey can you help me to repeat selected rows at top as well as on bottom of the page on each printing page?
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
Genius!
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?
Very useful video, why can't view in Playlist as a Powe Query in your channel
Thanks Ali, I'll collate all of the Power Query Videos in a single playlist
Gr8
is there a way to do this with google sheets?
how to reverse please guide