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 I want a new table with Columns 1/2/3: Red / Sky / 1-2-3 Basically merging or concatenating the contents of column 3 for rows in which values in columns 1 and 2 match. asked 20 Jun '12, 15:43 KenB |
Look at the LIST aggregate function. answered 20 Jun '12, 15:49 Glenn Paulley Thanks. Worked perfectly.
(20 Jun '12, 15:55)
KenB
|