Hi Dave.. I tired the Transpose, but couldn't get it in the right format.. it took the data horizontal, but it's still not what I need..

What I need to do, and it would take forever manually, is insert a new row between each existing row, then take what's in Col B in the above row and move it into Col A in the newly created blank row.. trying to find a way to manually do that.. or if I could just figure out a way for EXCEL to insert multiple blank rows, I could use a formula to move the data down..