| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change data from two rows into 2 columns
No problem, use the TRANSPOSE function.
=TRANSPOSE("Your Table Refernce") Remember you must select a range of cells the same size as your table before you enter the above formula (in the top left hand cell) and then execute with Ctrl+Shift+Enter because it is an array formula. -- If this helps, please click "Yes" <<<<<<<<<<< "Katherine" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
