Filtering only certain columns of a row to another worksheet
I am using Filter to move a copy of the data from one worksheet to another, but want to remove certain columns. Filter does not seem to allow that kind of manipulation. Is this even possible.
This is the FILTER statement I am using in the other worksheet: =FILTER(‘PI Package’!$A$3:$FA1600,(‘PI Package’!$A$3:$A$1600=”BUNDLE IDENTIFIER”),”NO RECORDS”)
which results in this output
I am using Filter to move a copy of the data from one worksheet to another, but want to remove certain columns. Filter does not seem to allow that kind of manipulation. Is this even possible.This is the FILTER statement I am using in the other worksheet: =FILTER(‘PI Package’!$A$3:$FA1600,(‘PI Package’!$A$3:$A$1600=”BUNDLE IDENTIFIER”),”NO RECORDS”) which results in this output Read More