Duplicate Rows in Power Query

--- LIVE Training Enrollment----

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

---
► Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[glaungani]

How do you duplicate just the first row and keep only 1st column data and ease the data from the other cells of the row added?

[nelson]

how can I repeat rows, but change one column (change an id number to something else)?

[sucharesh]

Wonderful explanation...I need one help ..i have a huge data in excel where i want to refresh the update the data only records has 16 row count ( Name has 16 repeated times) and remaining all should be excluded. May i know how to do that? or i want to remove the data which has 'Key text" contains....

[tashidawa]

Thanks for your wonderful videos. If sir could work on two column block of data where records repeat more then twice continuously and want to remove that records which are repeating continuously but not the one which is not repeating continuously despite same value from every block of data.

[mamamtl]

Hello, I need to duplicate rows only if a certain column is not empty. Can you provide this solution please?

[seankillilea]

Hey Chandeep...Appreciate you, why would this fail:

List.Repeat( {2022, 2023},
List.Repeat({"LEADERGIVE", "LEADERSHARE", "COMMISSION"}, 1), 1)

[mitultank]

I understand whole query, but I confuse that when we can use this?

[advocatedevendrasingh]

can we repeat the rows for more than 2milion times and then export the data in excel distributed as per excel sheet limit

[SAGARMATHUR-so]

how to delete filtered or selected rows in POwer query editor

[nancikalidin]

The data has duplicates which I want to use the excel formula true/false in power query to give the unique value as False and Duplicates ones as True In excel file, I will only use the formula as shown below to get the unique and duplicate data. Can this be done in power query? I need the duplicates value in order to use to calculate the total sum. The unique value will be the count..
How can I have use the true/false formula in PowerBI, count the data with duplicates and sum the total with duplicates for amount

[nonoobott]

Wow. Such a great tip. Learned a lot from your Channel. Thanks for sharing

[sarthakkhanna]

I was looking for this solution EVERYWHERE. Thank you kind sir!

[Justinthemovies]

Love your video's.
Question: how do i ad index in this duplicated rows?

[alexkim]

Thank you. This is the recent challenge I had faced a few days ago and I don't have the answer to it. I know it is definitely conditional and some iteration function is required but i dont know what function I should use.

[merwynpereira]

Thank you so much for your video.
I have another question. Is it possible to sort rows from left to right in power query. Just like we do in excel using sort function.

[ssi]

Hi sir I have many sheets and data extracting from data but in data around 8 rows have similar name and its data is different in column, i want to mark 8 rows as with Letter Q.column name and rest as the same. Please help me in resolving this issue, regards

[abduvosidmalikov]

How to do the same but vice versa: the rows are repeated twice => once for each position available. I want to show only one row for each employee with his latest position

[bixcel]

when expanding the list, i want to repeat 1, 2, 3 for a list to be repeated 3 times rather than writing 3, 3, 3. is it possible ?

[ΚρομμυδαςΚωνσταντινος]

Thank you very much! It solved my problem in a few clicks!

[kanwalsingh]

Hi Chandeep, how can I add "a" next to the duplicate value of a column please?