ExcelBanter - Advanced transpose (columns to rows)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Advanced transpose (columns to rows)? (https://www.excelbanter.com/excel-discussion-misc-queries/204213-advanced-transpose-columns-rows.html)

mcmilja

Advanced transpose (columns to rows)?

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

Dave Peterson

Advanced transpose (columns to rows)?

Check your other thread.

mcmilja wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 11:58 PM.