Merge two cell value in row to one value

[PoojaS5]

Hi ,

so this is the table i'm getting while trying to add data in powerBI

current output;

Desired Output;

 any solution would be appreciated thanks in advance

[tamerj1 · Accepted solution]

Hi @PoojaS5