Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anony_mous
Frequent Visitor

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:

Anony_mous_0-1693974285191.png

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

Anony_mous_1-1693974325890.png

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

Anony_mous

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @Anony_mous ,

 

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

vstephenmsft_0-1694503782585.png

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.

vstephenmsft_2-1694504055426.png

vstephenmsft_1-1694504040964.png

 

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.           

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.