Manually add text to specific cell in Power Query

[pigsinblankets]

Good Morning,

Due to how a data source is set up certain cells are pulling in as 'null' where there should be text (this can't be changed). 

Is it possible to manually add text to an individual cell in Power Query? I can find a lot of text transformation options for adjusting the entire column but I only want to add text manually to specific cells that is not pulled in from the data source.

Thank you! 🙂 

[punitkhatri]

Hii @pigsinblankets , 
If you want to edit cells manually go to power query and in the applied steps section, click on the source and then click on this little gear icon. Then you can edit your data manually.

Hope it helps and please let me know if this helps you or not.

 

[pratyashasamal · Accepted solution]

Hi @pigsinblankets ,

It sounds like you want to do accurately replace specific row values, right? If that's the case, you can take a look at the following link about M query operators(column: [string], row {number}), then you can do custom on replace function to achieve accurately replace value operations.

Operators - PowerQuery M | Microsoft Docs

Quick Tips: Conditionally Replace Values Based on Other Values in Power Query (biinsight.com)

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C