Make stacked columns into one row

First time trying to add files this way. Will retry if I messed up. There are two after options. One shows all of the stacked rows put where they should be and the other shows essentially just the info I need to be copied. ANother solution for me would be to copy items from a certain place to another place if a 3rd cell contains a certain character. In this case, it would be copy items from O3 into AH2 only if A2 ends with a "/" (or begins with a number would also work).