Advanced transpose (columns to rows)?

  • Thread starter Thread starter mcmilja
  • Start date Start date
M

mcmilja

Hello,

I am in need of a way to transpose a portion of a set of data from columns
to rows keeping a unique record of the data in column A.

Example:

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

Thanks!
Jaret
 
Check your other thread.
Hello,

I am in need of a way to transpose a portion of a set of data from columns
to rows keeping a unique record of the data in column A.

Example:

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

Thanks!
Jaret
Click to expand...
 
Back
Top