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