Prev: How do I set up a weighted formula in Excel?
Next: Conditonal formatting problem!
From: Katherine on 10 May 2010 20:12
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.
From: BSc Chem Eng Rick on 11 May 2010 02:03
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.
 | 
Pages: 1
Prev: How do I set up a weighted formula in Excel?
Next: Conditonal formatting problem!