Fill blank column with info

[AndrejZevzikov]

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?

[amitchandak · Accepted solution]

@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/

[AndrejZevzikov]

So easy :DDDD thanks

[Jihwan_Kim · Accepted solution]

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

[AlB]

Hi @AndrejZevzikov 

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.

[amitchandak · Accepted solution]

@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/