I need help on Power Query editor of Single Column data Splitting in to other columns

[Radhakrushna]

Hello Team,

I need your help on the below issue.

I have data in the one column(Column Name is Main in first image) as First Image. Need the same data as in another columns as like 2nd or 3rd image by using Power Query editor. 

Can you please help any one on this issue.

Thanks in advance. 

Regards,

Krishna

[Radhakrushna]

Hello Team,

I have data like below image and you can find the column "Main" which is highlighted in Red colur. 

and, I need the output as below image with hierarchy.

Please help me on this on bit priority. 

Regards,

Krishna

[v-stephen-msft]

Hi @Radhakrushna ,

What is the output logic you want? Can you share pbix with me?

Pay attention to hiding private data, this is a public forum.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

You can use sort hierarchy, first sort by column C ascending, later by D ascencing and E ascending.

In PQ editor barely visible numbers will appear to insicate sort hierarhy.

[Radhakrushna]

Hello Team,

I need the solution as given below image from Main column(Which is rounded with Red colour) of first image.

Regards,

Krishna