discostu
09-23-2010, 09:13 AM
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!
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!