Forum Discussion

Radhakrushna's avatar
Radhakrushna
Regular Visitor
4 years ago

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

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Radhakrushna
      Regular Visitor
      4 years ago

      Hello Team,

       

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

       

       

      Regards,

      Krishna

       

  • Radhakrushna's avatar
    Radhakrushna
    Regular Visitor
    4 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.