Forum Discussion
Helper IFill blank column with info
Hi guys maybe it's will be hard to explain so i will show what I have and what i want to have. I guess I need that to in power query, I have xml file import in power bi and go to transform data and saw something like this:
Date Client amount I want the result: Date Client amount
2020.12.31 Microsoft Inc. 100 2020.12.31 Microsoft Inc. 100
2021.01.31 80 2021.01.31 Microsoft Inc. 80
2021.02.28 20 2021.02.28 Microsoft Inc. 20
2020.12.31 Apple Inc. 120 2020.12.31 Apple Inc. 120
2021.01.31 70 2021.01.31 Apple Inc. 70
2021.02.28 50 2021.02.28 Apple Inc. 50
I want the client name copy on every blank column till next not blank and start fill all others columns with what. I thnik you know why i have file like this its from excel filterinf with "+", any ideas?
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/
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
4 Replies
- amitchandak
Super User
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/
- AlB
Community Champion
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.
- Jihwan_Kim
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
AndrejZevzikovSo easy :DDDD thanks
