Understanding Automatic Transpose Excel 2003

[sa.alex]

I'm currerntly working on a project and need to Transpose alot of information seeing it was formatted to be userfriendly to someone else, but its not friendly on my end since I am converting and organizing the data.


My question is, how can I use the Macros or can someone give me a code which will allow me to transpose this data, I have included a picture.

[ravishankar]

Hi
select the range, Copy, paste special > choose transpose
you can record a macro of this process and run it. If you have large no of blocks like this, you should let us know the layout of your data so that it can be automated
Ravi

[sa.alex]

Thank you, this is my code if anyone is interested

Please Login or Register  to view this content.

Lastly, is there a way maybe using Visual Studio 2008 to make an application that will do this for me automaticly with out me having to open excel? Where I could search the document in a directory, then click a button that will convert or automaticly do the transpose like I just did using the macros?

If anyone has any information in how to do this, please share your knowlage.

[Leith Ross]

Hello sa.alex,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross

[sa.alex]

Wow, thank you for being so supportive! I will read the rules and post my code properly from now on.