Help creating macro

[discostu]

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!

[davmec93]

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

[Aussiebear]

is this the one you are referring to?

http://office.microsoft.com/en-au/excel-help/convert-columns-to-rows-or-rows-to-columns-HP005203138.aspx

[davmec93]

is this the one you are referring to?

http://office.microsoft.com/en-au/excel-help/convert-columns-to-rows-or-rows-to-columns-HP005203138.aspx

Oh Ya! Thats the one! Thanks for help on that one. That should get him what he needs....do you agree?