Example data in column1
2|3|3|3GES|5|3
|3|334|3ere||343
I would like to split this by pipes so I can update the corresponding other blank 6 columns in each row.
Example Col1 Col2 Col3 Col4 Col5 Col6 Col7
2|3|3|3GES|5|3 2 3 3 3GES 5 3
I hope this makes sense! Any help is greatly appreciated.