Forum Discussion
AFra
Helper III
Helper IIITable transformation : columns become lines
Hi there, I have a 50.000 lines table with 23 columns such as : ID ability A ability B ability C ability D 12345 1 1 12346 1 1 1 1 12347 1 I'd lik...
AFra,
In Power Query, click on the ID column, and select Transform --> Unpivot Other Columns. Then rename the columns as desired.
DataInsights
Super User
Super UserAFra,
In Power Query, click on the ID column, and select Transform --> Unpivot Other Columns. Then rename the columns as desired.