Insert row using power query

[hardeep.kanwar]

Hi i have Unique data in column A,and in Column B i have number of duplicate on bases of Master Sheet,I need to insert the row if the count is more than 1.

can any body have idea to do this with Power query as i am not expert in VBA

 

[RoryA]

Make the data into a table. Load that into power query.
Add a custom column using the formula:

={1..[Count]}

That will add a new column with a list for each row, containing the numbers 1 to whatever the value of the Count field is. Click the double arrow button at the top right of the new list column, and choose Expand to new rows:

You can then remove the Count and Custom columns if you wish.

 

[hardeep.kanwar]

Thanks a ton ,work perfectly.

 

[RoryA]

Glad we could help.