text to columns

[mike]

Hello

I would like my present table with 2 columns:
ID tekst 1, tekst 2, tekst 3
ID tekst4, tekst5, tekst 6, tekst n

(text in second column is comma delimited)
....

transform to table with colums ID and as many text columns as needed:
col1 col2 col3 col4 col_n
ID tekst 1 tekst2 tekst3
ID tekst4 tekst5 tekst6 tekstn

Thx, Mike

 

[scubadiver]

Maybe you should think about changing the design (just a thought!)

 

[scubadiver]

I've just come across this:

http://support.microsoft.com/kb/210588/en-us

May help.