re: SQL Server 2012
I have a SQL table that has one column with comma delimited values in it (see example below)
I would like to be able to transpose that comma delimited column so i end up with something like this but i'm not sure how to accomplish in SQL
Any ideas much appreciated
NB I can do this quite easily outside of SQL (as i did in my example) but do not have that luxury with this particular DB unfortunately as it is managed offsite so hoping i can do it in a query?