Hello
I need some help creating a macro to transpose some excel data
The data is in this format
Column 1 Column 2
Day 1 .002
Day 1 .444
Day 2 .225
Day 2 .669
Day 3 .444
Day 3 .712
I need to put it in this format
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
Day 1 .002 Day 2 .225 Day 3 .444
Day 1 .444 Day 2 .669 Day 3 .712
Any help you can give me would be great!
Hi. You can actually do this without having to use VBA. I tried to post a link to the MS site with instructions but since I'm a noobie I'm not allowed. Do a google search for "Columns to Rows" and you'll get a Microsoft help link that will walk you right through it.
HTH
What happens if you get scared half to death twice?
is this the one you are referring to?
http://office.microsoft.com/en-au/ex...005203138.aspx
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Oh Ya! Thats the one! Thanks for help on that one. That should get him what he needs....do you agree?Originally Posted by Aussiebear
What happens if you get scared half to death twice?
Posting Permissions
Reply With Quote
