Copy only Used Parts of a Range

My list of the skill names are simply A121:A218 on a worksheet called Design, and their skill levels are B121:B128 on the same worksheet. There is only one person who has the skills, with the skill name being on the left, and their skill level being on the right. The destinations of the skill names are BI16:BI148, where rows are merged into twos (the cells are BI16, BI18, BI20) and the destinations of their corresponding levels are CD16:CD148, where the rows are once again merged into twos. Their destinations are on a worksheet called Character Sheet I. I'm not sure how to do the HTML thing you did, but if that's what you were looking for, let me know how and I will.