Forum Discussion

DeanP's avatar
DeanP
New Member
7 years ago
Solved

Create Duplicate Entries based on Column Value and change data entries

I want to add a duplicate of a row in my existing table based on value in another column in the same table using power query:   I have a column called 'ITM CODE' in my table.  I want, for every row...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi DeanP

    In Power Query

    Assume your table is "Sheet9"

    create a new blank query, open Advanced editor, write the code

    let
   Source= Table.SelectRows(Sheet9, each[ITM CODE]="SLMANFEE")
in
   Source

    then in this table, 

    click on the [ITM CODE] column, select "Transform"->Replace values,

     

    Then in Sheet9, select "Home"->Append Queries", Append Queries as new, 

     

    Please refer to my pbix.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi DeanP

In Power Query

Assume your table is "Sheet9"

create a new blank query, open Advanced editor, write the code

let
   Source= Table.SelectRows(Sheet9, each[ITM CODE]="SLMANFEE")
in
   Source

then in this table, 

click on the [ITM CODE] column, select "Transform"->Replace values,

 

Then in Sheet9, select "Home"->Append Queries", Append Queries as new, 

 

Please refer to my pbix.

 

Best Regards

Maggie