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: ...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

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

HotChilli's avatar
HotChilli
Community Champion
2 years ago

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

TexasXD1's avatar
TexasXD1
New Member
2 years ago

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