I have a long column with some numerical data and many empty cells and need to copy and compress it (ignoring the empty cells) to use in another spreadsheet. It is a monthly chore and is tedious to find and copy the around 30 cells containing data amongst the over 4000 empty cells. The cells with data are the result of a formula.
I have tried copying the entire column and then using Paste Only Numbers, but that didn’t work. (The whole column was pasted, empty cells and all.)
I have also tried Paste Special, enabling Numbers, Formulas and the “skip empty cells” option, but surprsingly that didn’t work either (same result – whole column pasted).
I must be missing some vital step but do not know what it is. Any help would be appreciated. Thanks very much.
Using LO v184.108.40.206 with Win7 Pro.