Hello there.

If I'm reading you correctly then you do want to try and transpose
your information by selecting it, cut or copy it, then select where
you want it to go, then right click that cell and choose the paste
special option, then check on the Transpose option and VIOLA!

And then you can use your autofill handle.

Did that help?

-Imonit

On Jun 6, 11:58*am, JG wrote:
I have worksheet like this:

A
B
C
A
B
C

That I need to look like this:

ABC
ABC

In both, each letter is in its own cell.

Is there one forumula that I can use to do all-at-once or do I need to do
each set (ABC) individually?

Thanks, JG