on 2012 Jun 20 4:43 PM
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.
Request clarification before answering.
Look at the LIST aggregate function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
60 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.