Need help with simple Macro
Solved/Closed
Hello,
I have an Excel worksheet with data in columns that I would like to move to rows. The data is in A1:AN1 - I would like to make it shwo in the worksheet in rows A1 thru A40.
Do you have a macro that will do this?
Thanks!
I have an Excel worksheet with data in columns that I would like to move to rows. The data is in A1:AN1 - I would like to make it shwo in the worksheet in rows A1 thru A40.
Do you have a macro that will do this?
Thanks!
Related:
- Need help with simple Macro
- Simple diagram of hard disk - Guide
- Spell number in excel without macro - Guide
- Simple tv windows - Download - IPTV players
- Mp3 music simple web browser atube catcher - Guide
- Macro excel download - Download - Spreadsheets
1 response
Hi Dave,
If I understood your question correctly, you don't need a macro at all to do this.
Here's how you do it.
1. Select all the columns (A1:AN1). Right click and select copy.
2. open a new sheet. Right click on cell A1
3. select Paste Special.
4. Check the box Transpose and press OK.
Thats it. You got the rows and columns transposed.
Hope this helps
Thanks
David
If I understood your question correctly, you don't need a macro at all to do this.
Here's how you do it.
1. Select all the columns (A1:AN1). Right click and select copy.
2. open a new sheet. Right click on cell A1
3. select Paste Special.
4. Check the box Transpose and press OK.
Thats it. You got the rows and columns transposed.
Hope this helps
Thanks
David
Sep 24, 2008 at 12:16 PM
And to think I thought I needed a macro!! I must say I feel a bit stupid right now...
Thanks again!