I'm currently trying to copy 8 columns of data onto the same sheet. The first 4 columns of the original 8 has a lot of blank spaces, because they are descriptions of a check that is broken into sub-details in the next 4 columns. Therefore, it only states the information of the check once and then just does new detail amounts in the second 4 columns. I need all the cells to be filled with their respective check data. So I've been transposing everything over onto a new 8 columns, using a ton of IF formulas that essentially take the data from their counterpart cell unless its empty, in which case it goes up until it finds a cell that isn't empty and takes that data. I need a separate IF function to go up every cell, so my formula is four lines long. Is there anyway to condense this?

Thanks