cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
ehchandlerjr
Level V

Are there ways to have different, overlapping groups of columns?

Hello - Are there ways to have multiple overlapping groups of columns? Right now, the best I can come up with is a script at the top right to select predefined columns, which is servicable until you have a bunch of scripts in addition to your grouping scripts, so if there's another way to do this, it would be nice.

Thanks!

Edward Hamer Chandler, Jr.
2 REPLIES 2
jthi
Super User

Re: Are there ways to have different, overlapping groups of columns?

If you want to have single column in multiple groups (or rather change the groupings) you would have to do it by scripting. I would most likely create some sort of an add-in which would let be define the groups, change the groups, possibly save them to a file for easy loading/table variable and add those group "swaps" to table scripts for easy usage.

This might give some ideas Save Current Column Order and Grouping 

-Jarmo
txnelson
Super User

Re: Are there ways to have different, overlapping groups of columns?

One way to handle this is by creating new formula columns who's formula simply points to the original column.  The new formula column can then be put into a new group.

Jim