shifting columns in some rows to the left

counter column nowin first column

split based on knownlast column being missingtop: Column11 is missing, so data is okbottom: Column 11 is missing so need to merge two columns

rememberoriginal row ordering

remove column I

put back in counter order

remove counter

@takbb componentrename lower table columnsbased on position of columnsin upper table

bring rowsback together

remove final columnby position

counter columnto top output

or just do it with pandas!