Forum Discussion
Replace null with relative cell reference
Hi, I am attemping to use Power Query to manipulate a downloaded report. The report puts data for a single invoice on multiple lines, I would like to reconfigure all relevant data onto a single line...
IN that case, why not Use the FillDown function on the Invoice Date column, thus filling in the nulls with the date above. Then you can filter out the nulls in the Product/Item Description.
---Nate
Woo-Hoo! Thank you Nate. I think that will work fairly well!!
I was able to fill up or down based on whether the first cell was "null" and because the data repeats evenly this was a very efficient solution!
Thanks again to all for help!
*<]:0) Happy Holidays to All!