Forum Discussion

Anony_mous's avatar
Anony_mous
Frequent Visitor
2 years ago

Issue in tranforming the data into structured data

Hi All,

 

I am new to power BI I got a data format of unstructured type I need to clean the data and bring into structured format This is the data format I received from client:

Expected result is  to transform the above data image  into 5 columns:

Please give some solutions all suggestions are welcome thank you in advance!!
Regards,

Anony_mous

Need Help
Show and Tell
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anony_mous ,

     

    Perhaps the best way is to manually remove the extra rows and columns and fill in the gaps.

    Your values also appear in the same column, and you may also need to use the Pivot Columns or Unpivot Columns features.

    Pivot columns - Power Query | Microsoft Learn

    Unpivot columns - Power Query | Microsoft Learn

    For example, with unpivot columns, the columns become rows.

     

    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.