Forum Discussion
Pivot/Unpivot two columns by value
For reference i am only using one column (Cust ID). I feel like this isnt hard but i cant figure out how to get my column data into multiple rows. I have attached an image -- seems pretty straightfor...
Anonymous
Create a new column e.g. Customer No and add the following formula:
Customer No = "Cust " &
RANKX (
FILTER (Sheet1, Sheet1[Zip]= EARLIER(Sheet1[Zip]) ), -- Grouping Column
Sheet1[Cust ID], -- Sorting Column
, ASC
)
Then Create a matrix visual and add the data.
I removed totals from the matrix and for values field (Cust ID) I used the MAX aggregation method.
See attached file