Imperial wrote:
I have text in rows that are in separate cells that I’m trying to convert
into columns; which I figure out how to do by copying the rows click on the
cell and in the paste special box I then checking off transpose which lays
the copied rows into columns. Now what I’m trying to do is the same thing;
however I want to be able to have lets say 10 cells that I copy in a row this
time when it puts into columns I only want 5 cells in that column and the
next 5 cells of the 10 copied I want it to go in the next column below. What
it’s doing with the 10 cells that I copied in the rows now when I transpose
them into a column is putting all 10 copies cells into 1 column which I’m
trying to split the 10 cell rows into 2 columns and so on. It’s got to be a
format or formula thing just unsure how to go about this. If someone could
help me with this it would be greatly appreciated. Hope I was good in
explaining.

So you want to transform

A B C D E F G H I J
1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20

into

A B
1 6
2 7
3 8
4 9
5 10
11 16
12 17
13 18
14 19
15 20

or what?