Data modelling

[Chaitanya_malir]

Hi all,

I am learning powerBI. i am struct up in one problem. I need to split row into column for every two spaces . how to do it in powerBI

[Chaitanya_malir]

no i want to split after each second space like a b must be in one row and c d in another row like that @Jihwan_Kim 

[Jihwan_Kim]

Hi,

One of ways to achieve this is to operate it in Power Query Editor.

Please check the picture down below that describes where to click in Power Query Editor.