mercredi 17 février 2021

Remove some columns from a table in Google sheets

I have different columns and I am trying to get the same information but removing some columns.

Is there a way to do this with a unique formula?

The goal to choose the resultants columns, it can be A, B, E or B, D, E, depending what you want.

I've tried with index and putting several values in columns (between {}) but it didn't work, neither with filter.

From this:

  A        B      C        D         E

Italy      1      a      apple      cat
France     2      b      pear       dog
Spain      3      c      banana     bird

to this:

Italy      a       apple
France     b       pear
Spain      c      banana

Aucun commentaire:

Enregistrer un commentaire