Hi
Some sample data below although I have more columns and alot more rows
What are the steps to convert
Into
I did unpivot the Data and got below but not sure how to group it so that it gives me a breakdown for each option
Some sample data below although I have more columns and alot more rows
What are the steps to convert
A1 | A2 | A3 | A4 |
cat | dog | cat | cat |
dog | cat | cat | dog |
chicken | chicken | dog | dog |
Into
Option | cat | dog | chicken |
A1 | 1 | 1 | 1 |
A2 | 1 | 1 | 1 |
A3 | 2 | 1 | 0 |
A4 | 1 | 2 | 0 |
I did unpivot the Data and got below but not sure how to group it so that it gives me a breakdown for each option
Attribute | Value |
A1 | cat |
A2 | dog |
A3 | cat |
A4 | cat |
A1 | dog |
A2 | cat |
A3 | cat |
A4 | dog |
A1 | chicken |
A2 | chicken |
A3 | dog |
A4 | dog |
