Forum Discussion
Solved
Automatically remove empty columns in a pivot table
Hi all, I have a database for my operator skills define per line and product. Out of this I made a pivot table to sort them as I want. but sometimes I have operators which are not trained for ...
Yannick_Smeets See attached! On the tab called "pt" I recreated the pivot table as shown in your picture. Below it, another one based on the same, but unpivoted, data. Used Power Query to transform your data, load it to the Data Model and then create the second pivot table how you want it. Added a sheet "unpivoted" to demonstrate what that means.
Thanks for the quick respons and the answer Riny. this is exactly what I needed 🙂
the only challenge now is that I'm not familiar with Power Query so I have something new to learn 🙂
the only challenge now is that I'm not familiar with Power Query so I have something new to learn 🙂
Yannick_Smeets Check out this link. It's good start.