Forum Discussion
Jenny_2663
Aug 20, 2024Copper Contributor
Is there a way to delete every-other cell going up or down in a single column? Every other row?
Hi, I have a long list (700+) of prices to paste into a column, but every-other row is blank. How can I delete it? Can I delete every other cell in a column? Can I delete every other row on a sp...
mathetes
Aug 20, 2024Silver Contributor
There no doubt are several methods. I would use the FILTER function to derive only cells with some value greater than zero. Then paste the resulting column.