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
You can upload the file containing the desensitized source data and the desired result to the cloud drive, and then share the link here.