Hello,
I have a data set that uses unique rows with columns identifying different attributes (Is Large, Is Small, etc.)that I am trying transpose into columns but only maintain the appropriate attributes. Which, I believe will have to be an additional step in the process. I am new to Alteryx, so any help would be appreciated.
| Current State | |||||
| Supplier | Is Small | Is Large | Is Medium | Is Little | Is Tiny |
| Supplier A | Y | Y | |||
| Supplier B | Y | Y | |||
| Supplier C | Y | Y | |||
| Supplier D | Y | Y | Y | ||
| I need it to look like this: | |||||
| Future State | |||||
| Supplier | Name | ||||
| Supplier A | Is Small | ||||
| Supplier A | Is Little | ||||
| Supplier B | Is Large | ||||
| Supplier B | Is Medium | ||||
| Supplier C | Is Medium | ||||
| Supplier C | Is Tiny | ||||
| Supplier D | Is Small | ||||
| Supplier D | Is Large | ||||
| Supplier D | Is Medium |
Solved! Go to Solution.
Thank you!
