id data
1 a,b,c
2 d,e,f,g,h
3 i,j,k
desired output
id data_1 data_2 data_3 data_4
1 a b c null
2 d e f g,h
3 i j k null
id data
1 a,b,c
2 d,e,f,g,h
3 i,j,k
desired output
id data_1 data_2 data_3 data_4
1 a b c null
2 d e f g,h
3 i j k null
read: Tally OH splitter and use that technique