copy the selection you want to reformat. Select an empty cell of where you
want your column to begin. Select Edit - Paste Special - in the lower right
check the box for "Transpose" This will reformat the rows into a column.

"RColeII" wrote:

I need to take a worksheet with columns A1, B1, C1, D1 and reformat those
into rows.

The end result should be:

C-A1
C-B1
C-C1
C-D1
C-A2
C-B2
C-C2
C-D2
etc.

Suggestions?