Unpivot Data - Power Query / Excel / SQL

[p4nny]

Hi

I have summarized data in the following format:

role	2021	2022	2023
admin	1	2	2

I would like to convert this so it is presented as:

role	year
admin	2021
admin	2022
admin	2022
admin	2023
admin	2023

I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this format. (Notice how the number of occurrences in the year column change as per summary above)

Thanks in advance for any help / guidance

 

[Fluff]

Duplicate Unpivot my data - Excel / PowerQuery / SQL

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).