I need to format the attached file but I don't know what could be the best route for me to do this.

For example cell A17 and B17 I need this information on row 19. So I would need to insert 2 more columns called Name, Account No. What formula can I use to find the best possible way to format this real quick. thanks!