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 simply use the FillDown function in the Graphical User Interface (select the date column first).
Then Table.Distinct(PriorStepName) or just select both columns and click "Remove Duplicates".
That's it!--Nate