Merge Rows into one row parsing two columns

Hello there, hope this is not a redundant thread. As in picture, I got a table where are stored users for certain applications and their roles. It could be reaaally nice to have one row for every...