Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data from Sales in rows for each month

Hi!   Im trying to get a table that has the information of the months in the rows (i.e.   SKU YEAR JAN FEB MAR APR... DEC 0001 2021    1   6      7      9       10 0001 2022    9   4      5    ...
  • HotChilli's avatar
    4 years ago

    In power query,

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