Switch columns with rows but different sizes

[the_mitten]

Hi, wondering if anyone can help me with this:

I tried the copy, paste special, transpose technique, but it keeps giving me an error that my ranges are of different sizes. I want to place all the dates down the first column (i.e. where the "St.6 FA"'s are, and the "St.6 FA" where the dates are. I also want to maintain all the data. Am I doing the copy, paste special, transpose technique incorrectly, or is there another way??? (Btw, my copy, paste for this post doesn't seem to like my chart data, so for clarity, the st.6 FA value for oct 1 is 1.1, and so on.)


Thanks

1-Oct-03 2-Oct-03 3-Oct-03 4-Oct-03 6-Oct-03
St.6 FA 1.1 0.62 0.6 0.95 0.5
St.6 FA 0.75 1.025 0.75 0.85 0.875
St.6 FA 1.025 1.025 0.975 0.975 1.5
St.6 FA 1.025 0.975 0.975 1.1
St.6 FA 1.1 0.775 0.875 1.18
St.6 FA 0.775 0.7 1.05 1.125

 

[the_mitten]

Never mind, I figured it out.

:wink: