moving x column values into x row values
 

Is there a easy way someone to point out to this excel newbie, how to
take the values in of column A, B and C in sheet1 and turn them into
row values. while displaying the empty row values as empty column
values?

So i would look like i rotated the sheet 90 degrees clockwise.

Thanks!


--
havey
------------------------------------------------------------------------
havey's Profile: http://www.excelforum.com/member.php...o&userid=31844
View this thread: http://www.excelforum.com/showthread...hreadid=515643

moving x column values into x row values
 

If it is only values that you require any they do not need to be
updated, copy the values and then paste special values and choose
transpose,

If the values need to be updated you would have to look at the offseft
function and using column() and row() as the values for row and column
this would swap the values

=OFFSET($A$1,COLUMN()-4,ROW()-12)

If the transposed data was to start in the cell D12 something like the
above would work. Just copy the formula to the other cells in you new
area

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=515643