Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need to develop a new table based on a database, but the columns that I need are rows in the data base.
My data is extracted like this:
But I need that my new table has a column "Left Front Strut Pressure " "Right Front Strut Pressure" like the following image from a pivot table in excel. This strut pressure data is part of the column NAME
How can you transponse the rows to make the values filter like this.
Thanks!
Solved! Go to Solution.
@csalvadorc , the Pivot table can help
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
Thanks!
@csalvadorc , the Pivot table can help
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |