Unpivot through M or ease

Question

I have below dataset.StudentCourse1Course2Course3Course1Course2Course1Course2Course3Course1Course2James01/02/2019&nbsp;12/08/2000Not CompliantNot CompliantYNY01/02/2021&nbsp;Jason28/09/202024/09/201911/09/2015CompliantNot CompliantNYY28/09/202224/09/2021John17/05/201818/01/2017&nbsp;Not CompliantNot CompliantNNN17/05/202018/01/2019Jenny12/01/2021&nbsp;08/09/2008Not CompliantCompliantYYY12/01/2023&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This data represents Student and courses they have done. First three course column shows courses and theie completeion date . Next two column shows Compliance of two courses. This goes on. I have done unpivot to see course name and their values in one column but my rows count has increased significantly. My columns have same course name but not all columns/course are repeating. Like course completion date is showing three course while compliance is showing for only two course. I want to see it as below outcome.&nbsp;JamesCourse101/02/2019Not CompliantY01/02/2021JamesCourse2&nbsp;Not CompliantN&nbsp;JamesCourse312/08/2000&nbsp;Y&nbsp;JasonCourse128/09/2020CompliantN28/09/2022JasonCourse224/09/2019Not CompliantY24/09/2021JasonCourse311/09/2015&nbsp;Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please help the way it can be done. Either M code or any other solution.Thanks

ryan_mayu · Accepted Answer

Junaid11&nbsp;
here is a wokaround for you . pls see the attachment below.

Forum Discussion

Unpivot through M or ease

2 Replies

Related content

Pivot / Unpivot?

Unpivot Column

Unpivot Question

Unpivot

Unpivot columns

Student	Course1	Course2	Course3	Course1	Course2	Course1	Course2	Course3	Course1	Course2
James	01/02/2019		12/08/2000	Not Compliant	Not Compliant	Y	N	Y	01/02/2021
Jason	28/09/2020	24/09/2019	11/09/2015	Compliant	Not Compliant	N	Y	Y	28/09/2022	24/09/2021
John	17/05/2018	18/01/2017		Not Compliant	Not Compliant	N	N	N	17/05/2020	18/01/2019
Jenny	12/01/2021		08/09/2008	Not Compliant	Compliant	Y	Y	Y	12/01/2023