jana
asked on
Use excel transpose or similar
Hi,
We have a super big excel with over 1,200 rows 255 columns (rows=modems, columns=ports). We have been using excel transpose to just have 2 columns modems and ports (see below example).
We want to convert the data into 2 columns as follows:
We have used excel transpose, but we have to do this one row by row.
Is there a way for using transpose or another function so we can get the result we are looking for?
(attached sample files of current and trying to accomplish)
We have a super big excel with over 1,200 rows 255 columns (rows=modems, columns=ports). We have been using excel transpose to just have 2 columns modems and ports (see below example).
Modem Port-01 Port-02 Port-03
-------- ------ ------- --------
NetGear 4672 555 SMS
Arris non x SMS
We want to convert the data into 2 columns as follows:
Modem Ports
------------------------
NetGear 4672
NetGear 555
NetGear SMS
Arris non
Arris x
Arris SMS
We have used excel transpose, but we have to do this one row by row.
Is there a way for using transpose or another function so we can get the result we are looking for?
(attached sample files of current and trying to accomplish)
Try attached, press button to run.
Columns-to-Rows.xlsm
Columns-to-Rows.xlsm
ASKER
Thanx! I thought that there was a way with transpose, but thank you, VBA is the way.
Prior closing the question,
- Can you give a brief on the statement "Set wsIn = ThisWorkbook.Worksheets("S heet2")"
- Also, in the real excel we have over 200 columns, where do I increase the value to consider converting those columns also to rows?
Prior closing the question,
- Can you give a brief on the statement "Set wsIn = ThisWorkbook.Worksheets("S
- Also, in the real excel we have over 200 columns, where do I increase the value to consider converting those columns also to rows?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
ASKER
Columns-to-Rows.xlsx