Need help with simple Macro

Solved/Closed

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

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!

Need help with simple Macro
Simple diagram of hard disk - Guide
Spell number in excel without macro - Guide
Simple tv windows - Download - IPTV players
Macro excel download - Download - Spreadsheets
Excel macro to create new sheet based on value in cells - Guide

1 response

Answer 1 / 1

David
Sep 24, 2008 at 12:07 PM

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

Dave
Sep 24, 2008 at 12:16 PM

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!

Similar discussions

Samsung b310e sim unlock code and restore code

samsung Mobile GT-E1200Y unlock code

E1200Y sim lock password

Phone lock code for gt-e1200y

Similar discussions

Subscribe To Our Newsletter!