Need help in data preparation

Hi DiKi-I ,

You can use pivot columns and merger queries in Power Query.

Here's the solution.

1.Start by adding an index column to each table. This index column is designed to prevent errors when pivoting with multiple elements in a row.

2.Pivot columns in each tables.

Take the first table as an example, select the Parentname column and click Pivot Column.

Seleclt Parent column as values and select 'Don't Aggregate'.

Repeat the above steps to get three tables as follows:

3.Merge them.

4.Expand the column contains tables and merge again.

Expand it again.

5.For the same columns, you can merge them.

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.