Excel copy table into the three columns

Question

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 Answer

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]: