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!