| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change data from two rows into 2 columns
Hi I have the following Data
Staff A Cellular Phone xxxx Staff A Residential Phone xxxx Staff B Cellular Phone xxxx Staff B Residential Phone xxxx How do I change the rows into columns i.e. Celluar Phone for one column and Residential phone for the other with the correct telephone number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| change data in rows to be viewed in columns | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
Threaded Mode
