Link to home
Start Free TrialLog in
Avatar of sakthikumar
sakthikumar

asked on

convert comma separated values to different rows

Hi,

I have rows like below.

role                                                                                                                        ID
-------
Cloud Success Manager,Enterprise Cloud Architect                                     6620A17C28DBD796E0530C37548C2D68
virtual,Town Hall                                                                                                  66209194F2307DB3E0530C37548C276E


I want to convert it like below rows

Enterprise Cloud Architect                         6620A17C28DBD796E0530C37548C2D68
Cloud Success Manager                              6620A17C28DBD796E0530C37548C2D68
Town Hall                                                       66209194F2307DB3E0530C37548C276E
virtual                                                              66209194F2307DB3E0530C37548C276E

How do I achieve this?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial