Trying to create VBA code to transform one workbook form into another

I've attached a spreadsheet of what I need it to do. The "what I want it to look like" section, is actually another workbook. So far, I've gotten the code to list the proper number of variables in column A, ignoring the blanks, except I'm having trouble figuring out a way to pull the none blank information and place it next to the correct variable.