View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HollieH HollieH is offline
external usenet poster
 
Posts: 2
Default Flipping data - columns to rows and visa versa

Is there a way to "flip" my data so that the columns become rows and the rows
become columns? In other words, I have a spreadsheet that has employee data
listed for each employee vertically down the column. I can not sort vertical
data so I want to rotate it 45 degrees so that it is listed horizontally like
a normal spreadsheet would be. Is there any way to somewhat easily do this
in Excel? I have 07 at work and 03 at home. Either will work for the
project I am working on. Thanks for ANY help !