Multiple records one column separated by comma (,)
Multiple records one column separated by comma (,)
(OP)
Hai all
I am working on something like this. Hope someone can help me.
Consider this as sample data
Field1 Field2
John GA
Mark FL
Steve MI
John CA
John IL
Can someone assist me on a query to have data like this?
Field1 Field2
John GA, CA, IL
Mark FL
Steve MI
Thanks a lot..
I am working on something like this. Hope someone can help me.
Consider this as sample data
Field1 Field2
John GA
Mark FL
Steve MI
John CA
John IL
Can someone assist me on a query to have data like this?
Field1 Field2
John GA, CA, IL
Mark FL
Steve MI
Thanks a lot..
RE: Multiple records one column separated by comma (,)
Nitin
RE: Multiple records one column separated by comma (,)
ht
A.
RE: Multiple records one column separated by comma (,)
Handled it two ways:
1. Importing through MS Access to DBMS
2. Changing the column deliminator to something else, like |