Data from Sales in rows for each month

Question

Hi!&nbsp;Im trying to get a table that has the information of the months in the rows (i.e.&nbsp;SKU YEAR JAN FEB MAR APR... DEC0001 2021&nbsp; &nbsp; 1&nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp;100001 2022&nbsp; &nbsp; 9&nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20020 2021&nbsp; 11&nbsp; 40&nbsp; &nbsp;32&nbsp; &nbsp; 17&nbsp; &nbsp; &nbsp; 500020 2022&nbsp; 22&nbsp; 119&nbsp; 28&nbsp; &nbsp;78&nbsp; &nbsp; &nbsp;32to a "list"SKU YEAR MONTH SALES0001 2021&nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; 10001 2021&nbsp; &nbsp;FEB&nbsp; &nbsp; &nbsp; &nbsp;60001 2021&nbsp; &nbsp;MAR&nbsp; &nbsp; &nbsp; 70001 2021&nbsp; &nbsp;APR&nbsp; &nbsp; &nbsp; 9...0020 2022&nbsp; &nbsp;DEC&nbsp; &nbsp; 32&nbsp;Is there a way to do this while creating my query?

hotchilli · Accepted Answer

In power query,
select first 2 columns, right-click and 'UNpivot other columns'

Forum Discussion

Data from Sales in rows for each month

1 Reply

Related content

LAST MONTHS SALES

need to display monthly sales and 6 month average sales for products

Calculate Previous month Sales Month to date sales & last day sales

Monthly sales budget data allocation to daily grain

Dynamic Rolling 12 Months Sales Based on Selected Month