We have a scenario with the data as
ID | FDRT
1 | FDR-1234-12345,FDR-12345-123456,FDR-0000-0000
2 | FDR-3456-3456,FDR-23456-23456,FDR-45678-45678,FDR-1234-12345
The FDRT Column is of datatype ntext. What we intend to achieve is split the FDRT column into max 255 character and transpose based on ID. When we do the split each FDRT value should come as a valid value. The FDRT values are of variable length and comma separated. So if a line goes to 257 and hence is chopping of a bit of any FDRT value then move the last FDRT in this Column to next row.