Transpose and repeat values

Question

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 Answer

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 Answer

Hi @Goncal

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