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
Reverse Index Match 2
Formatting Numbers to Text or??!!! 6
How to Count Dates in 2 Lists 3
Pls help for Simple Calculation 1
Pivot Table Summarizing Quirk - Please Help 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Combine multiple rows into one. 2

Top