Switching rows and columns

B

Brurobiney

Hello wise ones, how do you make everthying in column A format to Row 1, and
everything in Row 1 format to column A? Basically just switch them around.
 
D

Don Guillett

Have a look in help index for TRANSPOSE

--
Don Guillett
SalesAid Software
[email protected]
Brurobiney said:
Hello wise ones, how do you make everthying in column A format to Row 1, and
everything in Row 1 format to column A? Basically just switch them
Click to expand...
around.
 
D

David McRitchie

Look up TRANSPOSE Worksheet Function in your Excel Help.

The example transposes a single row to a single column
More impressive if not limited to a single row or column but
the technique is the same.

Might be a good time to mention Peter Noneley's workbook example
which can be downloaded from Ron de Bruin's home page
http://www.rondebruin.nl/id.htm
 
Top