Forum Discussion
Solved
Create new table by transposing/Crosstab a data table
Hi, I need to crosstab/transpose data from one table to create a new table as shown in example below. Original Table: User Week Status A1 Week1 Active A1 Week2 ...
In matrix viusal , Week on column , Max of Status measure as value
Or if need a new table, Unpivot in Power Query- Take max of status -> If it does not give Option, After table is created you will see List.Count in script(formula), Make that List.Max
This is a classic pivot/crosstab use case. Use User as the row key, Week as the column headers, and Status as the value field, with an aggregation like First (or Max if there's only one status per user/week). If you share which tool you're using (SQL, Excel, Power Query, Alteryx, etc.), we can provide the exact solution.