mike1142
asked on
One Colum Casuing Multiple Rows
I have Col1, col2 and col 3.
Col 3 has multiple values where col1 and 2 do not. I need something in col3 but either row would do.
How can I fix this?
Col 3 has multiple values where col1 and 2 do not. I need something in col3 but either row would do.
How can I fix this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was being lazy. I'll bet a row rank thing will work
Example
Cols are
Name
Number
Colors
Joe likes green and red
Row 1: joe 1001 red
Row 2: joe 1001 green
I'd don't care if joe likes green and red just that joe likes a color and what it is.
What I want is one row for joe with one of the.e colors he likes but just one row.
Example
Cols are
Name
Number
Colors
Joe likes green and red
Row 1: joe 1001 red
Row 2: joe 1001 green
I'd don't care if joe likes green and red just that joe likes a color and what it is.
What I want is one row for joe with one of the.e colors he likes but just one row.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How about one row with colors in a comma separated list?
ASKER
Thanks. Worked fine.
Can you provide some sample for your data that how it looks and what you want as output. That would help great