Forum Discussion
Unpivot Multiple Row Levels into Columns (attributes)
Hello All, Does anyone know the best way to Unpivot the multiple Rows into Columns? Example Move the Type 1, Type 2,FY, Month into Columns, while keeping the 3 Column values into a Single Column V...
Hello All, I was able to acomplish this via a concatenation of the attributes into a single columns, then transposing the entire table and unpivoting all the columns into rows.
Thanks all for your help and inputs!
Hi Clara,
Try to concatenate all your main categorization attributes (because once you transpose and you will loose columns), then move this concatenated New Column to the begginign of the table (1st Column).
Then Transpose the entire table and promote to headers (you should see the concatenated column at header level)
Now select the values column and Pivot into a single column.
Lastly just delimit your concatenated column to have all your attributes back broken in columns,
Oh I see! Thank you! I'll try that