moving x column values into x row values

H

havey

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!
 
D

Dav

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
 
Top