Copying Columns of Data to Rows

[Walter]

I have two columns of data and want the first column in a certain row and the
second column in a few rows below the first but in the same column since the
information is related. For example:

Col A Col B
1xxxx 1yyyy
2xxxx 2yyyy
3xxxx 3yyyy

I want it like this

Col F Col G Col H
Row10 1xxxx 2xxxx 3xxxx
Row15 1yyyy 2yyyy 3yyyy

Does that make sense?

 

[DC]

Can't you just copy then paste special 'transpose'?

 

[Walter]

Yeah, that's right. Boy, sometimes you get blinded to the obvious

 

[DC]

Walter, please rate this as a helpful post.

Thanks