Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
TexasXD1
New Member

Creating new rows in dataset based on other columns

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:

TexasXD1_0-1712243206251.png

 

 

After:

TexasXD1_2-1712243260560.png

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

That looks like : select userid column and 'Unpivot other columns' in Power Query

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

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!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors