cancel
Showing results for 
Search instead for 
Did you mean: 

How to evaluate and merge cell values.

Former Member
2,436

How would I merge multiple cell values into rows of another table? If this is the example of rows from a table with Columns 1/2/3:

Red / Sky / 1
Blue / Sand / 1
Blue / Sand / 2
Red / Sky / 2
Red / Sky / 3

I want a new table with Columns 1/2/3:

Red / Sky / 1-2-3
Blue / Sand / 1-2

Basically merging or concatenating the contents of column 3 for rows in which values in columns 1 and 2 match.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member

Look at the LIST aggregate function.

Former Member
0 Kudos

Thanks. Worked perfectly.