A COLUMN to Multiple Rows

Copper Contributor

My list is a bit more complicated - However basically i want to convert my list in column 1  into Rows as shown, the List is a fixed number of cells for each Person in this example name and 5 Number s 

boss BOSS12345
1 DAVE11234
2       
3       
4       
5       
dave       
1       
1       
2       
3       
4       
8 Replies

@Don_Scarboni I you are on a recent Excel version you can use WRAPROWS

Riny_van_Eekelen_0-1677660653200.png

 

@Riny_van_Eekelen  I dont have Wraprows in my list thanks for responding so quickly though

 

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

 

 

Is this what i refer to as a Pivot table?

@Don_Scarboni 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?

2016
Your Power Query is in there and someone with more knowledge than me has shown me where it comes from