This is rather cumbersome way to do it and there may be better ways.
Original data is in column A. In Column B1 insert formula =$A1 and drag copy that formula down column B so that B2 become =$A2, etc. Then copy column B and paste transpose that column. You can hide column B when finished.
This thread is now locked and can not be replied to.