Convert Row to a Column-- using direct formula or macro?????

Source: http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/

This site just have a method to do in Excel menu bar not using formula, but it helped.