Hi,

1. If you only want to do it once then if your data is in cells A1:E5
enter the following formula in cell H2
=A2
copy this to the right 3 columns, to column J.
Next select the range K2:N2 and type but do not enter the following formula:
=TRANSPOSE(E2:E5)
Now press Shift+Ctrl+Enter

2. If your data continues down in exactly the same way for many rows then
enter the formulas as above
Select the range H2:N5 and drag the fill handle down as far as you need.

Your results will be spaces three rows apart but that is no problem. If you
want to compact them:
1. Click the column letters H:N and
2. press F5, and choose Special, Blanks and press OK.
3. Choose Edit, Delete, Shift cells up.

Finally, you can convert the formulas to values by copying the range of
formulas and choosing Edit, Paste Special, Paste values.


--
Thanks,
Shane Devenshire


"mcmilja" wrote:

Hello,

I am in need of a way to transpose some data from columns to rows

FROM
CIRCUIT_PATH_ID PORT_NUM PORT
EAGLEVILLE 470 1-1 PORT1 T1-5/0/0:09:01
EAGLEVILLE 470 1-1 PORT2 0961-01
EAGLEVILLE 470 1-1 PORT3 0738-18
EAGLEVILLE 470 1-1 PORT4 01-1

TO:
CIRCUIT_PATH_ID PORT1 PORT2 PORT3 PORT4
EAGLEVILLE 470 1-1 T1-5/0/0:09:01 0961-01 0738-18 01-1