Mar 01 2023 12:35 AM
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 | BOSS | 1 | 2 | 3 | 4 | 5 | |
1 | DAVE | 1 | 1 | 2 | 3 | 4 | |
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
dave | |||||||
1 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 |
Mar 01 2023 12:51 AM
Mar 01 2023 12:54 AM
@Riny_van_Eekelen I dont have Wraprows in my list thanks for responding so quickly though
Mar 01 2023 12:57 AM
@Don_Scarboni Perhaps Power Query then. It's very well suited to do much more complex transformation with little effort. See attached.
Mar 01 2023 01:07 AM
@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?
Mar 01 2023 01:20 AM