| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Data from 1 format to another
I have data in this row type of format:
Name:xxx Address:xxx Phone Number:xxx With about 75 entries like this. I need to get it into a column type of format: Name Address Phone Number x x x The name, address, phone number are all similar-they came in a form. Is there a shortcut to moving the entries to the columns that I want them In? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Data from 1 format to another
northlake,
Highlight all of your cells and copy them. Then, create a new worksheet. Click in the uppermost leftmost cell in the new worksheet, it should be empty. On the paste tab (right-hand side of the toolbar) press the dropdown arrow to get more options, and click Transpose. I can't see your data, but this should do exactly what you need. Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data from other worksheet including entire format | Excel Discussion (Misc queries) | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Copying the data in and format of a cell to another cell | Excel Discussion (Misc queries) | |||
| Copying range format and formulae without data | Excel Discussion (Misc queries) | |||
| Copying Format Across... | Setting up and Configuration of Excel | |||
Linear Mode
