How to generatively fill 'null' cells

Anonymous 

output 

sample data used  :

steps 

step1 : create a config table in power query  , as follow : 

1.1 duplicate your table.

1.2 remove duplicates

1.3 filter column1 on not blank 

step2 : 

merge this table with your table on id =  id  and expand the column :  account_name ( in my scenario i named it Column1modified .

step3 : use the replace value feature under transform tab :  ( be sure yo select your orignial account_name column ) 

enter any data to replace with . 

in the code , modifiy the replace 1 with each [ column1modified]: 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠: