switch rows and column data

C

culbie

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
 
S

ShaneDevenshire

Hi,

Just in case you don't know where that command is:

2007: Home, Paste, Paste Special, Transpose
2002-2003: Open the Paste button drop down and choose Transpose
<=2000: Choose Edit, Paste Special, and check Transpose.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro for deleting Rows containing dates greater than "today" 0
Excel Date Setting 1
Rotate data by date 1
Transpose not working rows to columns 3
Excel Is this possible?? 3
generate a list from a single row of data 4
Changing columns into rows 3
Sorting a list of numbers 3

Top