Forum Discussion
Replace null with relative cell reference
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 you Nate,
I am not certain the Filter by Does not Equal or Remove Duplicates is a solution for this issue because there is data in other columns that is essential, see below. So if I filter to remove the "null" from one column it eliminates the pertinent data in the other column,
In this example I need the INV # WW2020ZL593, 9/9/20, Willow Park - Maya 20-Piece Flatware Set all on one 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