Hello everyone, I’ve a column with +32k rows of data which many are empty, I need to to copy that data and paste it on another sheet without empty cells, but it does not work. Here’s a brief example of what I’m doing:
Thank’s
Edit: for some reasons video won’t load, link: https://i.imgur.com/tXa1nDg.mp4
Hi, thank’s. Unfortunately as soon as I do this LibreOffice get stuck and I have to force quit it… Maybe dye to the fact that the data I’m trying to paste are formulas? In fact I don’t need to paste formulas but just the output.
Any solution?
Resolved by first copying and pasting everything as text and then applyng the solution proposed.
I would say »…paste special→everything except all and Formulas« …
It still paste empty values.
Of course, so its only the first step…the second step is the Filter-solution above!
