Hi
I have following header which are scrambled , i need my headers in sort order
input:
| RecordID | od_z_ritm | od_z_qna | od_z_aitm | z_qna | z_qna2 | z_qna3 | z_qna4 | z_qna5 | z_aitm | z_aitm2 | z_aitm3 | z_aitm4 | z_aitm5 |
top 2 column names can be added till 15 , z_aitm15,z_qna15 i would like to dynamically sort those columns
expected output:
| RecordID | old_z_ritm | od_z_aitm | od_z_qna | z_aitm | z_qna | z_aitm2 | z_qna2 | z_aitm3 | z_qna3 | z_aitm4 | z_qna4 | z_aitm5 | z_qna5 |