Forum Discussion
Solved
Power BI - Difficulty getting the data ready
Hi, I'm often encountering the same problem when getting my data ready. I'll put a small example hereunder. We have a table which looks like this: Date - CoworkerA - Cowo...
This is a good test case for using 'Unpivot Columns' in the Power Query Editor.
Select all the 'Coworker ...' columns first, then choose 'Unpivot' on the Transform menu
Just to make clear that I do know how to distribute the table manually. But with enourmous tables this would take way to much time.