Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have a dataset that contains the below. I would like to create new rows for each record that are based on values in existing columns. Is this possible?
Example:
Before:
After:
Solved! Go to Solution.
That looks like : select userid column and 'Unpivot other columns' in Power Query
That looks like : select userid column and 'Unpivot other columns' in Power Query
That looks to have done it. I was trying to unpivot without remembering the dropdown to change the way it does it. Thanks!
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
