Hi
I have summarized data in the following format:
I would like to convert this so it is presented as:
I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this format.
Thanks in advance for any help / guidance
I have summarized data in the following format:
2021 | 2022 | 2023 | |
admin | 1 | 2 | 2 |
I would like to convert this so it is presented as:
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.
Thanks in advance for any help / guidance