Forum Discussion
A COLUMN to Multiple Rows
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 ...
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?