Forum Discussion

Zuy_NA's avatar
Zuy_NA
Regular Visitor
5 years ago
Solved

Combine column

Dear HotChilli , Please help me to transfer data like this: Class Name1 Name2 Name3 Name4 Name5 Score1 Score2 Score3 Score4 Score5 1 A         6         2 B       ...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Hello Zuy_NA 

     

    In Power Query, select the Class column and 'Unpivot other columns'.

    Filter out the blank values in the Values column (use the dropdown).

    Use 'split by delimiter' on the attribute column (Using 'By Non-digit to digit').

    Select the 'Attribute1' column and choose Pivot from the Transform menu. Choose Value for the Values column and 'Don't aggregate' from the Advanced section. 

HotChilli's avatar
HotChilli
Community Champion
5 years ago

Hello Zuy_NA 

 

In Power Query, select the Class column and 'Unpivot other columns'.

Filter out the blank values in the Values column (use the dropdown).

Use 'split by delimiter' on the attribute column (Using 'By Non-digit to digit').

Select the 'Attribute1' column and choose Pivot from the Transform menu. Choose Value for the Values column and 'Don't aggregate' from the Advanced section.