Issue in tranforming the data into structured data

[Anony_mous]

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

[Anonymous]

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.