Zend certified PHP/Magento developer

Excel – How to stack multiple columns into one but Column A values stay the same?

What formula or macro can I use to take the table on the left and create the table on the right?

Current Table Left / Desired Table Right