Peterw_2506
Board Regular
- Joined
- Jan 28, 2011
- Messages
- 78
Hi Everyone,
I have a table in spreedsheet 1 (this data is sourced from an external source) and cannot be filtered. I wish to take this data and be able to filter the various (numerous) column.
If I copy/paste it into Spreedsheet 2 when I filter the blank cells of whatever column appear at the base of the table.
If I do a copy/special paste the link into Spreedsheet 3 and then filter the blanks always appear at the top of the table not the base.
Does anybody know how in Spreedsheet 3 to force the blank cells to the bottom of the table.
NB: I need the blank cells to remain not be removed from the table thru unchecking the box that states "Blanks"
Thank you in advance.
I have a table in spreedsheet 1 (this data is sourced from an external source) and cannot be filtered. I wish to take this data and be able to filter the various (numerous) column.
If I copy/paste it into Spreedsheet 2 when I filter the blank cells of whatever column appear at the base of the table.
If I do a copy/special paste the link into Spreedsheet 3 and then filter the blanks always appear at the top of the table not the base.
Does anybody know how in Spreedsheet 3 to force the blank cells to the bottom of the table.
NB: I need the blank cells to remain not be removed from the table thru unchecking the box that states "Blanks"
Thank you in advance.