Forum Discussion
Unpivot Multiple Row Levels into Columns (attributes)
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!
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!
Anonymous Sorry, would you mind explaining how you did it? I'm having the same problem and not having any luck doing it the way you said...
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
