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
Thank to All who assisting with this project. I am new to Power Query/BI, so I am slow in moving through the recommendations and am very grateful for the infomration.
I hope the below link works. It is a desensitized spreadsheet with two tabs. The first is the download report, the second is the configured report.
https://www.dropbox.com/s/hkw2kacult8tdpc/Report%20Downloads.xlsx?dl=0
Please let me know if I can present this better. Thank you again!