google sheets
Lets say I have a table like this:
A | B | C
1 | 4 | 3
Is it possible to group these columns together so that I can expand and collapse them with a specific formula. For example with SUM I would have one single column:
ABC
8
And after that expand them again if I need the detailed data.
There is an option to mege that is like Excel's merge and center option. You can search for help on Google docs help, but here is a link for help on merging Google docs merge.
I think you have two choices that would not suit you:
1) Put French into wherever you are importing from.
2) Once the range is imported, break the link (Copy, Paste special, Paste values only) so that deleting Ana in the source no longer causes her to disappear from the imported data.
Both the above can be avoided with a lookup table but to do so would be ‘ugly’ and if imported data is added to, rather than have parts deleted from it, could require a tedious amount of repetition. However it might be acceptable as a workaround.
Import to two different ranges and Copy, Paste special, Paste values only one of those. Add French to the converted version (the one no longer linked) and use that as a lookup table to place French where you would like, by searching for Jacques (and Ana and Peter) by cell reference from the linked version.
Best Answer
This is very easy with hiding/unhiding columns but not possible with a formula.