I need to filter data based on a criteria but the output
a) should have only selected columns (extract range).
b) the output column names to be of my own choice (not same as column names of the input data)
c) reformat the output columns - example, i need to design the output such that some of the columns will be moved as row values
Can this be done using Advanced filter (how) or i need to apply some other mechanism.