All Forums Database
sasnai 1 post Joined 08/16
29 Aug 2016
How to transpose row values

Hi, 
I have a data like
id    info
1     AB 1234 / CD 5678 / EF 9101.
I want output like this
id info
1 AB 1234
1 CD 5678
1 EF 9101
I tried using TD_UNPIVOT function but didnt get the required output.
Thanks in advance.

You must sign in to leave a comment.