In Google Sheets, I am using the filter formula to obtain a subset of my data, but I would like to reorder the columns of the output.
Here is a sample dataset, and below is the filter formula I'm using.
This gives me the sample of rows, but the columns are in the same order as the original table. Is there a way to reorder them, e.g. have the 2nd column be last and move all others one to the left?
I understand I can filter columns as well as rows, and with that could use a second filter wrapping the first one, but that would mean making a different formula in each column. Any way this can be done in one formula?