One column concadnate with another column

Closed
prasu - Feb 11, 2010 at 04:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 11, 2010 at 07:19 AM
Hello,
My problem is:
I like a table like this:
columnA columnB
Designer1 project1
Designer1 Project2
Designer2 Project3
Designer2 Project1
Project2
My requirement is:
columnA columnB
Designer1 project1
project2
project3
Designer2 project1
project2

Please give query to my mail.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 11, 2010 at 07:19 AM
Is this correct in your sample data ?

columnA columnB
Designer1 project1
Designer1 Project2
Designer2 Project3
Designer2 Project1
Project2
My requirement is:
columnA columnB
Designer1 project1
project2
project3
Designer2 project1
project2
0