Group by column name

Is there a way to group columns by column names. so if [Col1] and [Col2] and [Col3], i would like to create a virtual column grouping these columns because they contain the text “Col”

There is no inherent way of accomplishing this, but you can always create your own additional column in your table to use for grouping.

I’ve done this, it’s very helpful actually - especially since you can take over what the actual value used for grouping is and you can sneak in additional information.

1 Like