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
Zubair_Muhammad
Community Champion
Community Champion

@narasimhuluk 

 

You can select the column and then use the FillDown function in Query Editor/Power Query

 

fdown.png


Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@narasimhuluk 

 

You can select the column and then use the FillDown function in Query Editor/Power Query

 

fdown.png


Regards
Zubair

Please try my custom visuals

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.