How to display comma separated column value in diff rows in table visual ?

Hi,

In the Power Query windows, where you prepare the data, you can split the column:

And in the settings spit it into rows:

For each comma separated value, it generate a record:

Regards,

Oktay

If it helped you, would appreciate a KUDOS and mark my answer as a solution 😉 

Hi pratikrami  -Please follow the steps at power query editor.

Select the SITES column.
On the ribbon, choose Split Column > By Delimiter.
In the dialog:
Choose Comma ( , ) as delimiter.
Select Split into Rows (not columns).

output:

file FYR attached

Hi OktayPamuk80 ,

Thanks for quick reposnse. So this is the only way ..right ? Because I have other columns also in main table I wanted to avoid these expansion of rows. Is there any way using measure or anything, directly without increasing the rows and we can use the same comma seperated text field in table visual ?