Forum Discussion
Don_Scarboni
Mar 01, 2023Copper Contributor
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 ...
Don_Scarboni
Mar 01, 2023Copper Contributor
Is this what i refer to as a Pivot table?
Riny_van_Eekelen
Mar 01, 2023Platinum Contributor
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?
- Don_ScarboniMar 01, 2023Copper ContributorYour Power Query is in there and someone with more knowledge than me has shown me where it comes from
- Don_ScarboniMar 01, 2023Copper Contributor2016