Forum Discussion
How to Copy Value from Previous Row (Main Line) to Its Succeeding Rows (Details)
I'm trying to copy the Invoice # values to its succeding blank rows (or breakdown). Here's what my data looks like: Transaction Type Amount Invoice #1 blank Invoice $20 bl...
Hi, Anonymous
I suggest doing this in Power Query Editor.
Please make sure that the blank value need be shown as null, like the below video.
https://www.dropbox.com/s/tg7shb4lzkfi6n4/Presentation2.mp4?dl=0
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
Got it! Been using power query for a while but it's my first time to know about the Fill Down function. Many thanks!