Hi all,
We'd like to convert table format on the left to table format on the right;
I have used power query but able to arrange by APPNAME, by USERROLE in 1 file and by APPNAME, by USERGROUP in separate file only as per below.
How do i combine both in the format on the top right as mentioned above? Appreciate your help. Thx.