Inverting or Transposing X and Y Axes

if you want to turn the columns into rows and vice versa, then select your range of data, and copy it to the clipboard. then place your cursor in the top left-hand cell of where you want to paste the data (cannot be the same location as your original data range). then go to edit/paste special, and select transpose.


hth
kevin

Select your range then Cut, Select where you want to paste then PasteSpecialand Transpose (and it can be the same location as your original data range)

Iridium said:

Select your range then Cut, Select where you want to paste then PasteSpecialand Transpose (and it can be the same location as your original data range)

Click to expand...

Got that wrong! Brain not working! kskinne is right