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 StateSupplierIs Small Is LargeIs MediumIs LittleIs TinySupplier AY Y Supplier B YY Supplier C Y YSupplier DYYY I need it to look like this: Future State SupplierName Supplier AIs Small Supplier AIs Little Supplier BIs Large Supplier BIs Medium Supplier CIs Medium Supplier CIs Tiny Supplier DIs Small Supplier DIs Large Supplier DIs Medium

Transposing Data, having difficulty getting the tool to output correctly

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