Hello,This is piggy-backing off of a previous post I had made and I continue to struggle which is my fault because my real data has more columns of interest that I did not share (apologies for that). I have this fake data here BUT it is important to note that my real data has many more students than just #1-4. (It also has many more columns but they are not of interest). StudentIDLevelTestScoreCategory1High SchoolMath88Above Average1Middle SchoolEnglish90Above Average1High SchoolScience83Average1Middle SchoolScience89Above Average1High SchoolSocial Studies97Above Average1Middle SchoolSocial Studies88Above Average2High SchoolEnglish95Above Average2Middle SchoolEnglish90Above Average2High SchoolSocial Studies68Below Average2Middle SchoolSocial Studies78Average3High SchoolMath85Average3Middle SchoolMath72Average3High SchoolEnglish93Above Average3Middle SchoolEnglish90Above Average3High SchoolScience86Above Average3Middle SchoolScience95Above Average4High SchoolEnglish93Above Average4Middle SchoolEnglish89Above Average4High SchoolScience81Average4Middle SchoolScience87Above Average4High SchoolSocial Studies74Average4Middle SchoolSocial Studies70Average I want each studentID to have only 1 row for high school, 1 row for middle school, and the subjects to be in columns as in the table below. I have pivoted every way I can, and I have tried the DAX solution in my original post suggested by the very kind & helpful v-dineshya but I am not having success. Is there a way to achieve this? StudentIDLevelMathCategoryEnglishCategoryScienceCategorySocial StudiesCategory1High School88Above Averagenullnull83Average97Above Average1Middle Schoolnullnull90Above Average89Above Average88Above Average2High Schoolnullnull95Above Averagenullnull68Below Average2Middle Schoolnullnull90Above Averagenullnull78Average3High School85Above Average93Average86Above Averagenullnull3Middle School72Average90Above Average95Above Averagenullnull4High Schoolnullnull93Above Average81Average74Average4Middle Schoolnullnull89Above Average87Above Average70Average Thank you in advance!

afaherty This can be easily done with Power Query no need to use DAX for data transformation. let Source = RawData, Unpivot = Table.UnpivotOtherColumns ( Source, { "StudentID", "Level", "Test" }, "A", "V" ), MergeCols = Table.CombineColumns ( Unpivot, { "Test", "A" }, Combiner.CombineTextByDelimiter ( "_", QuoteStyle.None ), "Merged" ), Pivot = Table.Pivot ( MergeCols, List.Distinct ( MergeCols[Merged] ), "Merged", "V", ( x ) => x{0}? ) in Pivot

Issue with pivoting via DAX | Microsoft Fabric Community

Forum Discussion

Related content

Pivot issue

Power Query Pivoting columns issue

Pivot / Unpivot?

Averagex issue

Issue - Pivot/ Unpivot Scenario