Forum Discussion
Solved
Transposing Data
Hello I need assistance to help transpose data. I have team member names with their respective dates that they cross trained into another Line of business. I am trying to transpose data in BI but h...
I am new to this so I don't know if this is the best way, but what I did was replace all of the null values in the data with a date that couldn't exist. Then all columns had a value. When unpivot after this, the table has the correct structure. I then replaced the bad date value with null.
Below are screen shots:
I hope this helps!
Dawn
PS: If this solution works, please mark it as a solution, to help others. Kudos are nice too.
jcastr02 ,
Go to Power Query, Transform tab, Select first two columns, go to Unpivot Columns, and select Unpivot Other Columns.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel