How do I transpose one excel column of multiple names & addresses into many columns for EACH name & address?

Question

I want to have EACH name, address and phone number currently in a group within a single column (All "A") each transposed AUTOMATICALLY into its own column (A, B, C, etc.) side by side and done just as quickly as a "paste special" converts from "copy" using the "transpose" method. Thanks. Geoff

I simply want to move the list of name/address data from the "A" column" into multiple SINGLE columns for each Name and Address ... automatically. This is NOT the same as the "transpose"capability.

Answer 1

Data-->Text to Columns.

See this extreme tutorial...about 1/3rd down the page:
http://www.officearticles.com/tutorials/an_extreme_tutorial_in_microsoft_excel.htm

Answer 2

spotlight the column you opt to style by utilising. bypass to records (in the menu bar) --> style decide on "boost the call" click on style now choose for which column you needed taken care of and in what order. So if the names are in column A, choose for column A (or the call of that column), and then click the "ascending" radio container. Now click "ok"