Power BI Report Column format

[MVAdmin]

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

[MVAdmin]

Hi All,

I am facing the same problem. Please help me with this question. 

Thanks in Advance