Need to split the column Reference values for every 10 characters and need to show it for every row ID
I have data like this
ID Reference
1 405123 ap41502 ag067156
2 a450912 d109456
3 4a4122 g567412 ol09123 pl212671 et61789
4 6t3450 41234a3 01a459014
Required Result:
ID Reference
1 405123 ap
1 41502 ag
1 067156
2 a450912
2 d109456
3 4a4122 g
3 567412 ol
3 09123 pl2
3 12671 et61
3 789
4 6t3450 4
4 1234a3 0
4 1a459014
Aucun commentaire:
Enregistrer un commentaire