Transposing multiple rows into one column

[rfarnum]

Hello,


I am almost positive this is what I need, but mine is in opposite direction and I don't really understand how the formula (that LukeM posted) works to tranpose it. This is what I need done, hopefully someone can help.


1 2 3 4 5 6

to

1 2

3 4

5 6

 

[SirJB7]

@rfarnum

Hi!

Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on). One of them talks about hijacking other's posts, so please go to the Introduction topic, present yourself and then start a new topic.

Regards!