Forum Discussion

TexasXD1's avatar
TexasXD1
New Member
2 years ago
Solved

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:

 

 

After:

 

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

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

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

    • TexasXD1's avatar
      TexasXD1
      New Member

      That looks to have done it. I was trying to unpivot without remembering the dropdown to change the way it does it. Thanks!