Issue in tranforming the data into structured data

Anonymous

Not applicable

2 years ago

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.

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.

Forum Discussion