Forum Discussion
CSpina
Helper III
Helper IIIHow to transform rows in columns in a table with measures?
Hi, guys! I have a table where the measures are columns and I need to transform in rows: THe config is: I need the following table: Any ideas?
Hi CSpina ,
You can follow the below steps to achieve it:
1. Unpivot columns in Power Query Editor
- Select column EMP AUT, EMP CAM, EMP COM, EMP MOT, EMP ONI, EMPL SER and EMPL TRAT
- Navigate to Transform ribbon, click Unpivot columns and choose "Unpivot Only Selected Columns" optionUnpivot Only Selected Columns
2. Create a matrix(Rows: Attribute Columns: Coluna Values: Value)Best Regards
Rena
Hi CSpina ,
You can follow the below steps to achieve it:
1. Unpivot columns in Power Query Editor
- Select column EMP AUT, EMP CAM, EMP COM, EMP MOT, EMP ONI, EMPL SER and EMPL TRAT
- Navigate to Transform ribbon, click Unpivot columns and choose "Unpivot Only Selected Columns" optionUnpivot Only Selected Columns
2. Create a matrix(Rows: Attribute Columns: Coluna Values: Value)Best Regards
Rena