Power BI Report Column format

Hi,

I have 2 columns X and Y having comma separated values. I want to create a custom Column XY that will have data from both the strings in columns X and Y.

The below screenshot is the sample format in spreadsheet and need this to be achieved in the Power BI Report.

I am new to Power BI. Do help me find a solution.

Thanks in advance