need guidance for excel formula

input and sample outputs are demonstrated in the excel along with this post. please check it and give me a solution. Because I want to separate   data in the list as per the order sheet in my shop wi...