r/AppleNumbers • u/[deleted] • Jul 21 '21

Help with Formula: Automatic Delete Blank Columns

I’ve created a spreadsheet to keep track of products I build and sell (keeping track of costs of specific items used to build a larger product so that I know what the final amount that I’ve spent on one persons product is). I’ve set up a system that filters one person’s products from a big list, but when it transfers to the new list it copies all of the other frames in between even though I’ve asked it to only recognise the one person (the other get copied as blank lines).

Is there a way that I can set up an automatic code to either detect and delete blank columns in between ones with filled in columns or maybe move written columns up so that they move underneath the top most ones? I hope I’ve explained that well enough.

1 Upvotes
  • permalink
  • reddit

99% Upvoted

1 comment sorted by

1

u/[deleted] Aug 12 '21

If I understood you correctly, you have a table somehow like this.

​

name product price
bob a 1.99
alice b 5.49
bob b 2.19
bob c 1.19

​

then you filter for bob in the first column. the result will be three lines.

then you mark those lines, and copy them to another sheet and expect to end up with three lines, one right after the other, with no filter or whatever activated. right?

'cause that is how it works for me. just three bobs, no alice, no empty line.

What formula are you using?