Printable View
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
is this the one you are referring to?
http://office.microsoft.com/en-au/ex...005203138.aspx
Oh Ya! Thats the one! Thanks for help on that one. That should get him what he needs....do you agree?Quote:
Originally Posted by Aussiebear