Forum Discussion
Fill blank column with info
- 5 years ago
AndrejZevzikov , You have the option of power query fill down. Right click on the column in power query -> Fill -> Down
https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/
- 5 years ago
Hi, AndrejZevzikov
please check the below picture.
You can right-click the column name.
Sometimes, if it does not work, please change the blank to null.
Then, try fill-down option.
Sometimes, if it does not work, please change the blank to null.
Then, try fill-down option.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Just use the fill down option in PQ https://docs.microsoft.com/en-us/power-query/fill-values-column
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |