I have a spreadsheet with data down column "a" only (names, addresses, etc). I want to move the data so it goes across the page under "B" "C" "D" etc.... It needs to be the actual data (text), not a formula "repeating" the data....

Example:
Column A
Row 1 Laura M. Smith
Row 2 1234 Joy Lane
Row 3 Somewhere
Row 4 CA
Row 5 99999

Need it to be:
Column A Column B Column C Column D Column E
Laura M. Smith 1234 Joy Lane Somewhere CA 99999

Thanks for any input!!