Transposing Data

[jcastr02]

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 having some difficulty.  It requires the rows to sort of repeat with the team member name and hire date.  see screen shot

[dethompson97 · Accepted solution]

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]

Thanks , this worked!

[dethompson97]

Wonderful!  Thanks for letting me know!

Dawn

[Nathaniel_C]

Hi @jcastr02 ,

Changed row headings. And of course I enter 1 person to show proof of concept.
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

[Nathaniel_C]

@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