Forum Discussion
Transform Table from vertical to horizontal
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.
First of all, thank you very much for your quick support 🙂
I did the steps as you describe, but it does'nt work as I expected. See attached screenshot.
In this case, I only used the first row of source code.
"Source = Table.FromRows(Json.Document(Binary.Decompress(..."
Why the Issue-No are different from Issue-No in my table?
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.
Wow, thank you !
