Sequence Issue

Dear Experts,                        Greetings! I have an issue like below, where exported a list from txt file and it has report like below:-   Now, the empty cells, should be such that af...