0 - 1 of 1 tags for value separation

Hello, any one has solution for this? is there unpack udf with anyone and willing to share?
Problem:-
Column values:  abcd, 1234, 3456, 34656,......, nnnn
Desired Output:
col1     col2        col3              col4               coln
abcd    1234      3456            34656            nnnn