sakthikumar
asked on
convert comma separated values to different rows
Hi,
I have rows like below.
role ID
-------
Cloud Success Manager,Enterprise Cloud Architect 6620A17C28DBD796E0530C3754 8C2D68
virtual,Town Hall 66209194F2307DB3E0530C3754 8C276E
I want to convert it like below rows
Enterprise Cloud Architect 6620A17C28DBD796E0530C3754 8C2D68
Cloud Success Manager 6620A17C28DBD796E0530C3754 8C2D68
Town Hall 66209194F2307DB3E0530C3754 8C276E
virtual 66209194F2307DB3E0530C3754 8C276E
How do I achieve this?
I have rows like below.
role ID
-------
Cloud Success Manager,Enterprise Cloud Architect 6620A17C28DBD796E0530C3754
virtual,Town Hall 66209194F2307DB3E0530C3754
I want to convert it like below rows
Enterprise Cloud Architect 6620A17C28DBD796E0530C3754
Cloud Success Manager 6620A17C28DBD796E0530C3754
Town Hall 66209194F2307DB3E0530C3754
virtual 66209194F2307DB3E0530C3754
How do I achieve this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.