Forum Discussion
Need Suggestion to create calculated column using Power Query Step or column
Hi All, I need a legend to categorize the components that we used in my table ID Components 1001 A,B,C 1002 blank 1003 A, C I need a power query step or colunm t...
In Power query, go to Transform. Split Column by delimiter and choose comma. Highlight all columns except id and right click unpiviot columns.
Thanks
Joe