G
Guest
Hello,
I have a table that has three fields across (ID#, Q01, Notes). Under the
ID# column I have several customer IDs: 1, 2, 3, etc... And under the Q01
column is the response to a customer question in which they could choose
multiple answers: A, B, C, D, etc...
The problem arises in that if a customer has multiple answers, they are on a
separate line. For example, if ID# 1 answered A, B, and C the first three
rows would be:
1 A
1 B
1 C
I would like to make one row per customer ID#. That way I have one row per
ID#, for example:
1 A,B,C
I believe I need to use an IIF function and Concatenate, but I'm not
certain. Any thoughts?
Thank you in advance,
Jack
I have a table that has three fields across (ID#, Q01, Notes). Under the
ID# column I have several customer IDs: 1, 2, 3, etc... And under the Q01
column is the response to a customer question in which they could choose
multiple answers: A, B, C, D, etc...
The problem arises in that if a customer has multiple answers, they are on a
separate line. For example, if ID# 1 answered A, B, and C the first three
rows would be:
1 A
1 B
1 C
I would like to make one row per customer ID#. That way I have one row per
ID#, for example:
1 A,B,C
I believe I need to use an IIF function and Concatenate, but I'm not
certain. Any thoughts?
Thank you in advance,
Jack