Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
narasimhuluk
Frequent Visitor

Power Query Editor

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 

 

 

 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@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.

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.