Power Query Editor

[narasimhuluk]

Hi Folks 

can we copy a cell value and paste in different cell as we do in excel ...copy /Paste 

i have some thing like as 

column 

abc  --- cell1

null --- cell2

null ---cell3

bed ---cell4

null ---cell15

null ---cell6

i want to replace abe with first two nulls and bed with next two nulls ...

I cheched with replace values but it is replaycing all the null values but i want to replace only particular null cells not all of them 

how do we do that in editor 

[v-yuta-msft · Accepted solution]

@narasimhuluk ,

So your requirement is to replace values in specific cell, right? You can select one cell and right click, then click replace value.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.