Need help with simple Macro Solved/Closed

Question

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!

David · Answer

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

Need help with simple Macro

1 response

Similar discussions

Subscribe To Our Newsletter!