Copy the data. Select Paste Special... and check Transpose
--
HTH...

Jim Thomlinson


"culbie" wrote:

i created a long spreadsheet for my boss. I have dates going across the rows
and names going down the column.

We want to switch so dates are going down the rows and names go across the
columns

is there an easy to switch the data so i do not have to retype the data?

thank you for your help