Transposing multiple rows to columns

Question

Hi, I have an Excel list with a few hundred rows that I want to Transpose to a few columns.

I can copy / paste and transpose one row, or write a formula for a single row.
How would I transpond all Rows to columns at once?

	Hardware	Hardware	Hardware	Hardware	Software
RoleID	Type of Computer	Computer Monitors	CISCO VOIP	Tablet	Office 365
1001	Day Extender	2 Monitors	yes	No	Not Required
1002	Custom Order	2 Monitors	Yes	No	Not Required
1003	Day Extender	2 Monitors	Yes	No	Not Required
1003	Custom Order	2 Monitors	Yes	No	Not Required
1004	Day Extender	2 Monitors	Yes	No	Not Required

To:

Role ID	Category	Access Type	Default Value
1001	Hardware	Type of Computer	Day Extender
1001	Hardware	Computer Monitors	2 Monitors
1001	Hardware	CISCO VOIP	yes
1001	Hardware	Tablet	No
1001	Software	Office 365	Not Required

For All Rows

oliverscheurich · Answer

ezflow&nbsp;In this example i've copied range B1:F7 and then selected cell B20. Then right click with the mouse and paste options -&gt; transpose.

oliverscheurich · Answer

ezflow&nbsp;=INDEX($B$1:$F$7,COLUMN(A:A),ROW(1:1))You can try the above formula if you prefer this solution. I've entered the formula in cell B10 and copied across range B10:H14.&nbsp;

Forum Discussion

Transposing multiple rows to columns

2 Replies

Resources