A COLUMN to Multiple Rows

Question

My list is a bit more complicated - However basically i want to convert my list in column 1&nbsp; into Rows as shown, the List is a fixed number of cells for each Person in this example name and 5 Number s&nbsp;boss&nbsp;BOSS123451&nbsp;DAVE112342&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dave&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Answer

Don_Scarboni&nbsp;I you are on a recent Excel version you can use WRAPROWS&nbsp;

don_scarboni · Answer

Riny_van_Eekelen&nbsp; I dont have Wraprows in my list thanks for responding so quickly though&nbsp;

riny_van_eekelen · Answer

Don_Scarboni&nbsp;Perhaps Power Query then. It's very well suited to do much more complex transformation with little effort. See attached.&nbsp;&nbsp;

don_scarboni · Answer

Is this what i refer to as a Pivot table?

riny_van_eekelen · Answer

Don_Scarboni&nbsp;No, this is not a pivot table either. I guess you are not familiar with Power Query then. Which Excel version are you working with?

Forum Discussion

A COLUMN to Multiple Rows

Share

Resources

boss	BOSS	1	2	3	4	5
1	DAVE	1	1	2	3	4
2
3
4
5
dave
1
1
2
3
4