I have a table and I need to split characters within a table in easy way
<tbody>
</tbody>
it should become like this
<tbody>
</tbody>
and so on
Please advice the easy way!
Many thanks
ID | q1 | q2 | q3 |
1 | 0301|0303|0307 | 07065|07567 | 090861|090862|090863|090864|090865|090867|090869 |
2 | 0301|0303|0307|0308 | 07565|07567|07569 | 090861|090862|090863|090864 |
3 | 0301|0302 | 07457|07458 | 090861|090862 |
4 | 0301|0302|0304|0309 | 07457|07458|07459 | 090861|090862|090863|090864|090865|090867|090870 |
<tbody>
</tbody>
it should become like this
ID | q1 | q2 | q3 |
1 | 0301 | 07065 | 090861 |
1 | 0303 | 07567 | 090862 |
1 | 0307 | 090863 | |
1 | 090864 | ||
1 | 090865 | ||
1 | 090867 | ||
1 | 090869 | ||
2 | 0301 | 07565 | 090861 |
2 | 0303 | 07567 | 090862 |
2 | 0307 | 07569 | 090863 |
2 | 0308 | 090864 | |
3 | 0301 | 07457 | 090861 |
3 | 0302 | 07458 | 090862 |
4 | 0301 | 07457 | 090861 |
<tbody>
</tbody>
and so on
Please advice the easy way!
Many thanks