Excel copy table into the three columns

[sonal]

I am trying to achieve the following pattern of data using Alteryx. I have a sample dataset with products and 4 attributes. The result is desired in three columns with Product, attribute and their value.

Kindly suggest how this should be approached?

Sample Dataset -

   Sample Dataset

Desired Result

Result Expected

[Aaron_Harter · Accepted solution]

Hi @sonal, 

Check out the Transpose tool!  You'll likely want the [Prod] as the Key Column, with all other fields selected as Data Columns.  Then use a select tool to rename [Name] as [Attribute]: 

[sonal]

Thank you Aaron