using union in powerBI

Hi Experts,

I am downloading data from SurveyMonkey through the plugin, and the objective is to create PowerBI reports and dashboards using the data.

My table is in the following format

UserName     Application1     Application 2     Application3

ABC               AppA                AppB                 AppC

DEF               AppF                 AppE                  null

GHI               AppA                AppB                  null

JKL                AppE                 null                    null

Reports' requirement is to identify users and count of applications, something like this

ABC   3

DEF   2

GHI  2

JKL 1

Is there a way we can convert the original table to show something like this (and create reports sourcing it)

ABC               AppA               

ABC               AppB                 

ABC               AppC

DEF               AppF 

DEF               AppE 

GHI               AppA 

In a DB, I would have done it using union statements, as an example

select UserName,  Application1   as APP

union

select UserName,  Application2   as APP

union

select UserName,  Application3   as APP

any suggestions on how to do it in power BI

Thanks in advance

...