Excel 2003: Transpose (flip, swap, rotate) rows and cells.
I'm a new member and a beginner/intermediate user of Excel 2003. I tried to post this yesterday but I don't think it went through. If so, please forgive the duplicate post. (However, I added more information about the steps I've tried.)
I'm trying to transpose rows and columns. (Or swap or flip or rotate - I've seen all three words used for this function.) I've read several sites and followed the instructions but it isn't working.
I have this format: Columns A B C Rows 1 2 3
I need this format: Columns 1 2 3 Rows A B C
I need rows A-Z columns 1-31.
I don't have any data in the worksheet yet. I'm trying to set it up before entering the data.
Here's the steps I took:
Select A1-Z31 and copy it.
Move cursor outside the selected area.
Select A1
Click Edit/Paste Special/Transpose/Ok
(Nothing happens)
Select A1 and copy it.
Move cursor outside the selected area.
Select B1
Click Edit/Paste Special/Transpose/Ok
(Nothing happens)
Select A1-Z31 and copy it.
Open new worksheet.
Click Edit/Paste Special/Transpose/Ok
(Nothing happens)
What am I missing or doing wrong?
BJ Martens
|