Need help with simple Macro

Dave - Sep 24, 2008 at 10:22 AM
 Dave - Sep 24, 2008 at 12:16 PM

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?


1 reply

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

Thank You! Thank You!

And to think I thought I needed a macro!! I must say I feel a bit stupid right now...

Thanks again!