Jan 18 2021 01:16 PM
Hello,
I have a spreadsheet with 2000 items in it.
I need to rearrange the items so that similar items are next to each other.
When I do a filter and define the search as text, lets say for "fenders" it lists all the items I am looking for. That being said, if I select all the rows and columns and cut them and then go back to my normal list to past them where I want, All other items get deleted. I must be doing something wrong.
Jan 18 2021 02:13 PM
If you cut such selection it cuts both filtered and not filtered cells, other words entire range. Cuts also doesn't if GoTo Special->select visible cells only since it doesn't work on noncontiguous range.
You may copy/paste one range by another to other location.