Merge multiple columns under one column

Hi guys, i have a table from which i’m trying to group 3 different column names;

  • Value #Total profit CAGR
  • Value #Expectancy ratio
  • Value #Max drawdown

under one column named Actual. I’ve used the table transformations Merge series/tables and Organize fields by name where i hoped renaming the 3 value field to the same name, would group them nicely…but no.

Does anyone have an idea as to how this can be done? :slight_smile:

Make sure that all these fields have the same name, e.g. Actual on the query level:

Then merge transformation will merge them under one column.

Woudnt that mean i cant override the values individually for fx thresholds and coloring?

Alternatively, if i could group the values in columns 1, 2 and 3 under 1 (the first) column that would also work

Correct. It was not your original requirement. You asked for merge.