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
if you share you excel file, many peoples here can give you what you are after.
I am sorry to be a pest - but when I attempt to drag my sample WB, I get the error: "The file type () is not supported"
I have tried xlsm, pbix and others. I have been looking for general information about forum uploads, but I have not located information to assist. Thanks for your help!