Forum Discussion

DaubPitt's avatar
DaubPitt
New Member
4 years ago
Solved

Transform Table from vertical to horizontal

Hello Community, I read data from Excel files files that are stored in different folders. Every Excel file has the same structure. I performed some power query steps (as a beginner) to generate a ta...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DaubPitt ,

     

    Below are the setps.

    1.Select two columns(Hold down the Ctrl key while the mouse selects.), then click 'Unpivot Columns'.

    2.Remove the 'Attribute' column.

     

    3.Change the 'Value' column to text type.

     

    4.Group on ’Issue-No‘, choose some dummy operation for FULLNAME (e.g. Max, not "All Rows") and then adjust the generated code to combine the names.

     

    5.Spilt the column with ";".

     

    Result:

     

     

     

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi DaubPitt ,

 

Below are the setps.

1.Select two columns(Hold down the Ctrl key while the mouse selects.), then click 'Unpivot Columns'.

2.Remove the 'Attribute' column.

 

3.Change the 'Value' column to text type.

 

4.Group on ’Issue-No‘, choose some dummy operation for FULLNAME (e.g. Max, not "All Rows") and then adjust the generated code to combine the names.

 

5.Spilt the column with ";".

 

Result:

 

 

 

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.

 

 

Sebatanguay's avatar
Sebatanguay
Regular Visitor
3 years ago

Wow, thank you !