Transpose and repeat values

[Goncal]

Hi,

I have sales data like this (each month in a separate column):

And I needed like this:

I need to repeat every single row for every month I have, and add the month next to it.

I think that once I have the months in a single column, matching the sales should be easy but I am struggling with the first part.

Thank you so much

[Christina_H · Accepted solution]

Use a Transpose tool, with Product Line, Brand family and SKU as key columns and all months as data columns.  The output should have all the months in the Name column and sales in the Value column, which you can rename in a Select tool.

[christine_assaad · Accepted solution]

Hi @Goncal 

You can use the Transpose tool and configure it, as attached.

[Goncal]

Thanks! this was easy! I am new to Alteryx and couldn't figure out the transpose tool