Advanced transpose (columns to rows)?

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced transpose (columns to rows) function? 3
Formatting Numbers to Text or??!!! 6
Pivot Table Summarizing Quirk - Please Help 1
Pls help for Simple Calculation 1
Transpose data from columns to rows 3
Combine multiple rows into one. 2
TRANSPOSE ROWS TO COLUMNS 4
Transpose large column 3

Top